DATA02_LEVEL 1 model import issue

Highlighted
Contributor

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

4 REPLIES 4
Highlighted
Valued Contributor

Re: DATA02_LEVEL 1 model import issue

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.

 

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: DATA02_LEVEL 1 model import issue

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

 

Highlighted
Valued Contributor

Re: DATA02_LEVEL 1 model import issue

@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.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
Highlighted
Contributor

Re: DATA02_LEVEL 1 model import issue

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