Pipeline Data Copy Decimal type values are changed

[nutpapon_lim]

Hi,

I'm trying a simple experiment. I want to copy data from Tables in Lake house to csv Files in the same Lake house.

However, I found that the value of decimal data in Table is changed when it was written into File.

For example, if I have value 0.045 in Table, it will be 0.044999999999999998 in File instead. I just want to write 0.045.

The problem only happens on 3 decimal place values. I have tried to change the file type but it has not helped. 

I have attached the example. Please feedback me how to correct this. 

Thank you,

Nutpapon Lim

[spencer_sa · Accepted solution]

Looks like a (double) floating point to string conversion issue.  I get the same when I use a Copy Data activity to output some decimals.  Might well be worth raising as a support ticket in Fabric.  As a work around, use the decimal data type instead.

If when you have your decimal data stored in the table as the decimal type, you get the following.

Floats are marginally worse;

Another alternative would be to do the conversion in a Notebook.

If you found this answer helpful, please marks as a Solution to help others find it.