DATA02_LEVEL 1 model import issue

Hello Community,

I am trying to import SKU.Volumes data into the DATA02 module However, I am facing issues while importing.  Below is the step 1 

ankulkarni_0-1594664477483.png

STEP 2

ankulkarni_1-1594664535352.png

STEP 3

ankulkarni_2-1594664597610.png

STEP 4

ankulkarni_3-1594664640130.png

STEP 5

ankulkarni_4-1594664674648.png

 

FINAL OUTPUT

ankulkarni_5-1594664719705.png

 

Can someone please guide me? Thank you in advance

Comments

  • Hello @ankulkarni 

     

    You are almost there. The error message actually explains the issue.

    I don't know if you changed the data format in the CSV file but looking at the current format it's a date, not a time period 

    1/1/2019 is a date while 012019 is a time period.

    I suggest you keep the csv date format as it was (period) and import it as a period instead of date so you don't have to do extra work in the model.

     

    Based on what period format you will use pick an option on theTime mapping tab from either box 1 or Boc 2.

    Box 1 if your time period has a separator

    Box 2 if it doesn't.

     

    If you choose to keep the Time format as a date then you have to select the date, not period radio button.

     

  • Hi Einas, 

    I have not changed the csv format and tried selecting dates instead of period per below. 

    ankulkarni_0-1594665889848.png

    but, getting an error per below

     

    ankulkarni_1-1594665960687.png

     

  • @ankulkarni 


    From what I see, your date format is not Y-M-D as you selected but rather M-D-Y.

     

    Also, You could select the Match Name option and let Anaplan sort it out.

  • You are right! Thank you so much Einas. It worked

  • Hi there,

     

    I have done the same mapping. However, the fixed line item (volumes) does not show (volumes) doesn't show to be selected. Thanks in advance