Loading .csv File issue Numbers dots, commas

edited November 2024 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

Best Answers

  • 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:

    Cheers!

  • 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.

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In