Issue
When exporting Data as CSV in Tableau Desktop, or outputting a Flow in CSV format in Tableau Prep, Floating Point (decimal) values will display as Scientific Notation, or be truncated, depending on the below factors:
- If there are 9 or less decimal places, then the value will remain unchanged. (e.g. 1.123456789 will remain unchanged)
- If there are more than 9 decimal places but less than 16, and the value has less than 4 zeroes directly succeeding the decimal place, the value is truncated to 9 decimal places. (e.g. 12.00124563478932 becomes 12.001245634)
- If there are more than 9 decimal places but less than 16, and the value has at least 4 zeroes directly succeeding the decimal place, the value is displayed fully in Scientific Notation. (e.g. 0.00003005842567 becomes 3.00584E-05)