Numbers processor
Performs multiple transformations (formatting, comparing, rounding) on columns containing numbers.
The Numbers processor allows you to modify records with a numeric data type in a transformation flow.
Numbers properties
Properties to perform operations on numeric records.
The properties listed in this section are the default properties for all functions of this processor. Additional properties may need to be defined depending on the function you have selected.
Property | Configuration |
---|---|
Function name |
|
Columns to process |
Select the column or columns on which you want to apply a function in the list. Information note
If you want to apply the same function to multiple columns at once, click to open a tree view that allows you to select multiple columns. |
Create new column |
Enable this option to create a new column after applying the function. If you do not enable this option, the existing column will be kept and modified. |
To rename the processor, click the Edit icon that is displayed when hovering over the default name of the processor.
To edit its description, click the Edit icon that is displayed when hovering over Description.
Limitations
-
If the target platform is Amazon Redshift, rounding with ceil or floor will always return an integer, which will ignore the precision.