Like what you see? Have a play with our trial version.

Error rendering macro 'rw-search'

null

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This transformation is done directly on column fields once a step has been configured, and data is generated in the Data Transformation module. Follow these steps to perform a number precision transformation:

  1. Either click Click on the menu icon next to a numeric field’s name in the data preview panel, and select Number Precision.
    Image Removed

    Image Added

  2. Alternatively, you can Or click on the menu option next to a numeric field in the Configure panel, under the Fields tab.
    Image Removed

  3. A menu will appear for the selected field.

  4. Click on the

    , and select Number Precision

    option

    .

    Image Removed


    Image Added

  5. When the popup appears, enter a value for the decimal place to set the number precision.
  6. Then choose a rounding option. These include:
    • Round up: This always rounds up. For example, 33.2 will become 34.
    • Round down: This always rounds down. For example: 28.9 will become 28.
    • Round half up: Rounds up if decimal point is 0.5 or higher, otherwise rounds down.
    • Round half down: Rounds down if decimal point is 0.5 or lower, otherwise rounds up.
  7. Click on Submit.

  8. The affected column field will be updated with the changes.

...