Loading .csv File issue Numbers dots, commas

Lilich
Lilich
edited November 5 in Modeling

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

Tagged:

Best Answers

  • AjayM
    AjayM
    Answer ✓

    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:

    image.png

    Cheers!

  • Dikshant
    Dikshant
    Answer ✓

    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.

Categories