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.48
- Floating: 9.4795889
- Int: 9
Choose 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