For budget data, I would like to replace a comma with a dot and keep it as a numeric value.
While I load a Excel Sheet as the Input Data the number shows up correct (for instance 0.083721) when I run my Workflow
the output in the .csv file is shown like 8,37209E+12 while I want it to show up like 0.083721.
What should I do?
Take a look at this article. You may want to look at Fixed Decimal.
hey @Nick_Fisher to my knowledge CSV may use scientific notation for very large or small numbers in order to reduce the number of characters in the cell/file as a whole so this may be why this happening if you save as XLSX does the same happen?
Thank you for your reactions.
The Fixed Decimal definitely helped in Alteryx, the results are what I would like to see in the .csv file or even a .xlsx file. But if I view the data there it's different from Alteryx.
I would like to get the Alteryx data. But it changes during the conversion to .csv or. xlsx unfortunately.
I have added some screenshots. Alteryx has the correct way of with a dot, while Excel looks different and has a comma.
If you open the file in a Text Editor how does it look? Does it look like it does in Excel or Alteryx? I am wondering if maybe the setting in Excel is not set correctly.
User | Count |
---|---|
18 | |
14 | |
10 | |
6 | |
6 |