Excel floating point issue

Richard Illyes

Hello.

I am on ADS 2.8.8 currently and I am facing an issue when trying to load .xlsx as a dataset. Some, but not all floating point numbers are read incorrectly (see screenshot below).

I have read the post below and understand this might not be possible to resolve instantly I just wanted to ask that aside from using other file formats for data loading (and rounding with a view/workflow), is there a way to prevent or work around this?

In addition, is there any fixes or updates in later ADS version that attempts to address this?

Thanks in advance.

Richard

https://community.experianaperture.io/discussion/149/floating-point-numbers-with-microsoft-excel-open-xml-spreadsheet-xlsx-files

Josh Boxer

Hi Richard, you found the discussion with the best information. Since Excel has already changed the number in the XLSX file there isnt anything that can be done on the Data Studio side. CSV file will have the correct value stored and be parsed accurately