Exponent values are not properly converted to decimal when doing import for CSV filesDescriptionIn CSV file imports, numbers using exponential notation are not converted correctly during transformation.Steps to Reproduce Create a table with decimal, floating point, and integer fields. For more information, see the documentation topic Create a table. Load and transform a CSV file with the value 9.4795888E7 into a floating point number, decimal, and integer field. Create a transform map and map to decimal, floating point, and integer fields in the target table. For more information, see the documentation topic Transform Maps. Run the transform and examine the target table. Note that instead of the expected value of 9.4795888, the actual values are: Decimal: 9.48Floating: 9.4795889Int: 9 WorkaroundChoose from one of the following workarounds: If you are using a CSV file, convert any in exponential "E" number format to a standard number in the CSV file before importing it.On the transformation map, for each field map from an exponential field, set the source [script] as: answer = Number(source.<field containing the exponential>.toString()); Convert the CSV file to an Excel file, the run the import on the Excel file instead. Related Problem: PRB812656