D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Data management import - Map the source to staging

  • 1.  Data management import - Map the source to staging

    Posted Nov 26, 2019 09:53 AM

    Hi Everyone,

    I hope that there is someone that might be able to answer me, as I am not sure what the best way to tackle this challenge.

    I have been tasked with setting up a data import and map the source to staging, but the source file I have received does not contain any headings I can use to reference the entity.

    I hope the one of you can help answer my question.

    Is it possible to do a mapping without the headings as references?

     

    I have attached an image of my dilemma.




    ------------------------------
    Patrick R
    Support
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Data management import - Map the source to staging

    Posted Nov 26, 2019 03:25 PM
    Hi Patrick,
    You should be able to do that if you set the 'First row header' to 'No' on your source data format.


    ------------------------------
    Andrew Xu
    Application Architect
    The Jackson Laboratory
    Bar Harbor ME
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Data management import - Map the source to staging

    Posted Nov 27, 2019 09:41 AM
    Hi @Andrew Xu
    Thank you for the quick answer, it was exactly what I was looking for. :) ​

    ------------------------------
    PatRas
    Support-DK
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role