Output to csv file round to billions when display value is rounded to 6 decimals

[sebastian123Han]

Hey!
I have a problem with my CSV output. The data I'm outputting looks like this in alteryx:

where 6.41088 is rounded to 6 decimals for clarity. However, when I output this to a csv file with the following:

the output in the csv file is the following:

Where 1.6 is correct, however, the first number should be 6.4108800000004 and not the insanely high number.

I can overcome this issue with output to an yxdb file. However, I would really like it as a CSV file.

Can anybody help here?

[atcodedog05]

Hi @sebastian123Han 

Sadly I am not able to replicate the issue. Its working properly for me. I have attached the workflow and output for your reference.

Try opening the .csv file in notepad and check the numbers once whether it's the same with high numbers.

Hope this helps : )

[binay2448]

It is working fine for me also, I am getting correct output.

[danilang]

Hi @sebastian123Han 

What is the field type for the column in error?

Dan

[sebastian123Han]

Hey Dan,

the field type is a double 🙂

[sebastian123Han]

Thanks for the answers everybody - the issue was resolved by simply deleting the output and add a new output file.