Highlighted
Contributor

Level 2 Sprint 2 - Dem01 data uploading wrong information

Hi All - I am trying to upload the Volume+Growth+Rates.csv https://anaplanenablement.s3.amazonaws.com/Files/Level2_onDemand/Volume+Growth+Rates.csv . The first time I tried, I got the error. 

 

sunilramakumar_0-1588745403517.png

 

So I changed the format on the excel to date 03/04/12 and tried again and it uploaded. But the values are showing up as below, which appears no relation to the data in the sheet. Can you please advise what I am doing wrong

 

sunilramakumar_6-1588745826381.png

 

Data in sheet

sunilramakumar_7-1588745849978.png

 

Added information

sunilramakumar_1-1588745629665.png

sunilramakumar_2-1588745664019.png

sunilramakumar_3-1588745691831.png

sunilramakumar_4-1588745735731.png

sunilramakumar_5-1588745756062.png

 

 

 

 

 

 

6 REPLIES 6
Highlighted
Master Anaplanner/Community Boss

Re: Level 2 Sprint 2 - Dem01 data uploading wrong information

@sunilramakumar 

 

I would recommend not to change the format into dates.Here is what you can do

 

Step 1: Without opening the Input .csv file upload the file into Anaplan It so happens when you open csv files it changes the period format. But if you wish to open the file before loading it, it may look like this

 

Misbah_0-1588751739303.png

You can try change the format in your source file . Right Click on any Cell and click on Format Cells and choose the option of "mmm-yy" Once that is done save the file.

Misbah_1-1588751882899.png

 

Alternatively if you want to save yourself some time just download it again from the exam portal and use that without opening

 
 

Step 2: Keep the time mapping as Period of M-Y on Anaplan. 

Misbah_0-1588751520941.png

 

You should be able to see the results as expected

Hope that helps

Misbah

 

Highlighted
Contributor

Re: Level 2 Sprint 2 - Dem01 data uploading wrong information

Hi Misbah - Thank you for your inputs. But I am getting the error:

 

Option 1:

sunilramakumar_1-1588782164293.png

Is this something related to the date format that I have selected ? ( There seems to be no year in the file)

sunilramakumar_2-1588782547002.png

 

 

Option 2 :

sunilramakumar_0-1588781829425.png

 

Highlighted
Contributor

Re: Level 2 Sprint 2 - Dem01 data uploading wrong information

Checked with mentor and he advised changing the date format to Y-M and it uploaded correctly. Thank you all for the help

Highlighted
Occasional Contributor

Re: Level 2 Sprint 2 - Dem01 data uploading wrong information

Do you know why the Y-M format worked?  I was stuck on the same issue forever

Highlighted
Contributor

Re: Level 2 Sprint 2 - Dem01 data uploading wrong information

Hi Rachel - I am still a novice, but my understanding is that the Y-M maps to the source and the input file has that format

Highlighted
New Contributor

Re: Level 2 Sprint 2 - Dem01 data uploading wrong information

One thing to do before importing such files is to open it in notepad and check the Date format.

 

For this file, you will see it has 20-Jan, 20-Feb, etc. (Y-M) format. Hence if you select Y-M when uploading this file, it will be uploaded successfully.

 

Thanks!