Replace ',' with '.' in a numeric value.

Question

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?

cjaneczko · Answer

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.

Nick_Fisher · Answer

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.

Excel.png

Alteryx.png

Deano478 · Answer

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?