DATA02_LEVEL 1 model import issue

ankulkarni

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 

STEP 2

STEP 3

STEP 4

STEP 5

 

FINAL OUTPUT

 

Can someone please guide me? Thank you in advance

einas.ibrahim

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.