Data Import Increasing Value

i'm having an issue importing data into our data hub module. i did not change any of the field characteristics, it has a minimum significant digits of 4 and is in number format.

The problem comes that when importing the CSV file, there are 0's being added to the end of the number that increases the numbers value.

You can see in the examples that the ProdAmount is supposed to be 12, but then when imported it becomes 1,200. And again 726,375.47 becomes 72,637,547. This happens for every number in the import. I've tried updating the data type in our CSV to general and number format, and updating the anaplan number format to no avail.

Does anyone know the cause of this issue and how to fix it?

thanks,

Kevin

number_format_129355.PNG

Excel_Import_12_129355.PNG

Anaplan_1200_129355.PNG

72k_Excel_Import_129355.PNG

72k_anaplan_129355.PNG

Accepted answers

KirillKuznetsov

@kmillet

You have to check import data source settings for this import. Probably in discimal separator is set to comma or somthing.

Also i would check which column do you use as unique key for your import. This may be the case that you uploading the same number x100 times because you are missing some unique identifier.

Hope it helps.

Kirill

All comments

KirillKuznetsov

@kmillet

You have to check import data source settings for this import. Probably in discimal separator is set to comma or somthing.

Also i would check which column do you use as unique key for your import. This may be the case that you uploading the same number x100 times because you are missing some unique identifier.

Hope it helps.

Kirill

ChrisAHeathcote

@kmillet

Check how you have defined the decimal separator and thousand separator in the import.

If your source data has changed how these are defined you will need to make sure that you can use a more consistent source.

kmillet

Thanks! the issue was the comma/decimal separator in the import.

appreciate the help!

Enis

I experienced the same problem and I solved it thanks to your advice. Thank you.

Quick Links

Can you help?

Unanswered questions

L2 Import DEM01
Hi all, i'm trying to import the file DEM01 csv but i don't know how to do it How do i select th evalue of DEM01 if the time value is on column? thanks a lot Andrea
ADO File Upload - Semicolon Delimiter
Hi, Based on the regional settings, my default delimiter/separator for CSV files is a Semicolon. In the classic way of uploading a csv file, I was able to select the delimiter. When using ADO, I don't have the option to select a delimiter. Uploading a Semicolon delimited file returns an error, or an upload with only one…
Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…