1.4.3.2 Import Data & Add Formula

zoecassell
zoecassell
in Modeling

I'm getting an error for Sku and Product Code after importing Sku csv

 

Does anyone understand why this is based on my screenshots?

 

Thanks!

zoecassell_0-1641914892410.pngzoecassell_1-1641914920288.pngzoecassell_2-1641915018318.png 

zoecassell_3-1641915105125.pngzoecassell_4-1641915141008.png

 

 

Tagged:

Best Answer

  • ChrisAHeathcote
    ChrisAHeathcote
    Answer ✓

    @zoecassell 

    Check the tabs in the import definition to ensure that the columns in the source are mapped to the correct line items in the target. 

    They may need to be manually assigned to the correct line items. 

    Always check the mappings in these tabs before running the import. 

Answers

  • Thijso
    Thijso

    Hi,

    Did you add a code into the list SKU Flat?

    Thijso_0-1641917731763.png

    I think Anaplan don't know which product you are importing because he doesn't know the product code.

     

    Hope this can help.

    Grts,

    Thijs

  • zoecassell
    zoecassell

    Yes mine looks just like yours.

    zoecassell_0-1641920741802.png

     

  • zoecassell
    zoecassell
    Thank you! Can't believe I missed that.
  • JeemarieB
    JeemarieB

    Hi, what formula did you use for the code line item? Instrcutions did not indicate this.

    image.png

  • Flame
    Flame

    i think Code(item(SKU Flat)) .

    Rohan

Categories