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:

I had selected (see below) or attached image

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

Many thanks

Rachael

Selection_97934.JPG

Accepted answers

Abhiram K

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

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

JaredDolich

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

All comments

Abhiram K

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

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

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?

Similar to this?

Many thanks

Rachael

JaredDolich

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

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385