Level 2 Sprint 2 - Dem01 data uploading wrong information

sunilramakumar
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

 

 

 

 

 

 

10 REPLIES 10
hpatel
Occasional Contributor

Hi Cynthia,

Please check my comment above. Open the file you're trying to load in notepad. Check the format and select that format when you go through the upload exercise.

For the Dem01 data, it should be Y-M format.

Once you change the csv file in any format, save it and open it in notepad to ensure it retains the format that you wanted to use.

Hope this helps.