Loading .csv File issue Numbers dots, commas

Lilich · 2024-11-05T14:47:42+00:00

There was an error rendering this rich post.

Hello,

I have an issue when loading my .CSV file, the number I get they are not right: when importing, the system takes the dot from the numbers as being the number not the decimal. For ex, in the CSV file I have 22.2 so twenty-two point 2 and in Anaplan I get 222. Can anyone help with that please?

thanks

Accepted answers

AjayM

Most likely, it's the "decimal separator" setting when you first create the import action using a file. Make sure it's set to dot:

Cheers!

Dikshant

Make sure to check all the settings above which Ajay mentioned and validate the data, that changing any File Option, does not break any other data. You need to run the action again after making these changes.

All comments

AjayM

Most likely, it's the "decimal separator" setting when you first create the import action using a file. Make sure it's set to dot:

Cheers!

Dikshant

Quick Links

Can you help?

Unanswered questions

Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
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.…