Performing mathematical operations on numeric values

For numeric attributes, you can perform mathematical operations. The available operations change based on whether the attribute you select is an integer, long, or double value.

The options can include:
  • Getting the absolute value
  • Rounding decimal values
  • Change a real number to the largest previous integer (floor) or the smallest following integer (ceiling).

To perform mathematical operations on numeric values:

  1. In the Catalog, select a project.
  2. Select Transform.
  3. Select the column of the attribute you want to change.
  4. From the transform menu, select Basic and the mathematical operation you want to perform on the attribute.
    When you select a numeric transformation, it is immediately added to the transformation script. There is no configuration, and the change always overwrites the selected attribute.

If you are done making changes to the project data set, you can commit the changes. See Running the transformation script against a project data set.