Problem with decimal separator when importing

Hello!

I have a very small issue when importing a .csv file into my model. I have designated 'comma' as my decimal separator, but Anaplan changes it to a point for certain data entries after doing the import, despite only having the comma as the decimal separator in the import preview . I am adding a couple of screenshots to better illustrate this.

Do you know why this is so? What am I missing?

Thanks a lot in advance!

Tomas

List_data_145970.png

Import_data_preview_145970.png

Accepted answers

KirillKuznetsov

Hi @TomasGomezVilla

Please try to change Number format settings of the desired line item.

You can select Decimal symbol there.

All comments

KirillKuznetsov

Hi @TomasGomezVilla

Please try to change Number format settings of the desired line item.

You can select Decimal symbol there.

TomasGomezVilla

@KirillKuznetsov

Thanks a lot for the help!

Unfortunately it doesn't seem to have changed my data, even after purging and recharging it. Do you have any additional tips?

KirillKuznetsov

@TomasGomezVilla

Please check selected decimal in import data source setting:

TomasGomezVilla

Thanks once again!

I had to specify that my data had no thousands separator.

Thanks!

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…