201 views

Description

In CSV file imports, numbers using exponential notation are not converted correctly during transformation.

Steps to Reproduce

  1. Create a table with decimal, floating point, and integer fields.

    For more information, see the documentation topic Create a table.

  2. Load and transform a CSV file with the value 9.4795888E7 into a floating point number, decimal, and integer field.

  3. 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.

  4. 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

    data is truncated as the E notation is ignored

 

Workaround

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

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2017-09-12 16:35:40
Published:2017-03-22