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

Question

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?

sebastian123Han · Answer

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

sebastian123Han · Answer

Hey Dan,

the field type is a double 🙂

danilang · Answer

Hi @sebastian123Han

What is the field type for the column in error?

Dan