Data import

Chau
Occasional Contributor

Data import

Hi,

I was trying to import the volume file to REV02  Volume Input (Level 1 lesson 8.5.3), but I received an error message about the column header in the file do not match the import definition as below: 

 



Chau_0-1613380378088.png

I had selected (see below) or attached image

Chau_2-1613380533747.png

 

I believed the column header was wrong. Will appreciate someone could assist me please.

Many thanks

Rachael

 

 

 

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
abhi1017
Super Contributor

Re: Data import

hi @Chau 

 

All mappings are right ,just need to select the right time pattern from the options w.r.t time pattern in the source file.

If still it isn't successful, use custom fixed pattern and type  as in the source file.

 

Hope it helps.

 

~ABhi

View solution in original post

JaredDolich
Moderator

Re: Data import

Rachael @Chau 

@abhi1017 is most likely correct. This import is a little tricky. Other things to note:

  • Make sure you set the header row to line 2 of your file. 
  • Date format is YYYYMM

DateFormat01.png


Jared Dolich

View solution in original post

JaredDolich
Moderator

Re: Data import

@Chau 

Yep. Just click on the pivot icon. Looks like the letter "L" backwards with arrows on it and in a box. Drag and drop your lists how you want them.


Jared Dolich

View solution in original post

4 REPLIES 4
abhi1017
Super Contributor

Re: Data import

hi @Chau 

 

All mappings are right ,just need to select the right time pattern from the options w.r.t time pattern in the source file.

If still it isn't successful, use custom fixed pattern and type  as in the source file.

 

Hope it helps.

 

~ABhi

View solution in original post

JaredDolich
Moderator

Re: Data import

Rachael @Chau 

@abhi1017 is most likely correct. This import is a little tricky. Other things to note:

  • Make sure you set the header row to line 2 of your file. 
  • Date format is YYYYMM

DateFormat01.png


Jared Dolich

View solution in original post

Chau
Occasional Contributor

Re: Data import

@JaredDolich Hi Jared,

Thanks for the help, and it worked!!! 

Is there any way that I could change the view in my model; currently the view is horizontal. Is it possible to have a vertical view with the listed skus?

 

 

 

Chau_0-1613458330661.png

Similar to this?

Chau_1-1613458477808.png

 

Many thanks

Rachael

 

 

JaredDolich
Moderator

Re: Data import

@Chau 

Yep. Just click on the pivot icon. Looks like the letter "L" backwards with arrows on it and in a box. Drag and drop your lists how you want them.


Jared Dolich

View solution in original post