Data import

Chau
Chau
in Modeling

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

 

 

 

 

Tagged:

Best Answers

  • abhi1017
    abhi1017
    Answer ✓

    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

  • JaredDolich
    JaredDolich
    Answer ✓

    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

  • JaredDolich
    JaredDolich
    Answer ✓

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

Answers

  • Chau
    Chau

    @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

     

     

Categories