Data Import Increasing Value

Options
kmillet
kmillet Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Extensibility

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

 

 

 

 

 

 

Tagged:

Comments

  • kmillet
    kmillet Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

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

     

    appreciate the help!

Categories