where am I going wrong in mapping these?

Hamzashaikk
Hamzashaikk
in Academy Discussions
image.png

Answers

  • pyrypeura
    pyrypeura

    Hi,


    To second mapping you want to set column headers instead of Column 1.

  • Dikshant
    Dikshant

    Map it with Column header.

    Go to line item mapping tab.

    Check if all line items are mapped properly

    Make sure to set the format of the date using the checkbox in target mapping

  • Hamzashaikk
    Hamzashaikk

    so line item mapping tabs are for to check if they are mapped correctly?

  • Hamzashaikk
    Hamzashaikk
    image.png

    what about this? this confuses me a little bit, how do I map correctly?

  • pyrypeura
    pyrypeura

    Hi,

    I'd suggest reviewing header row and first data row in the file setup you did one step before.

  • Hamzashaikk
    Hamzashaikk

    can we connect thru DM? @pyrypeura

  • Dikshant
    Dikshant

    Hi,

    You're missing quite a few things in this import. Firstly, import the file again, and set header Row to 2 and First Data Row to 3 as if you see header starts from row 2 as row 1 has Volume and not the Headers.

    image.png

    Secondly, this is how you're supposed to map the items:

    image.png
    • Map time with Column Headers
    • Map P2 Products with Column 1
    • Map G3 Location with Column 2
    • Map REV02 Volume Inputs Line Items to Fixed Line Items and go to REV02 Line Items tab and select volume line item.
    • Map the time format from Time tab.
    image.png

Categories