Numbers processor

Performs number related operations.

The Numbers processor allows you to apply various functions to fields with a numeric data type, such as formatting, comparing, or rounding numbers.

Usage

The Numbers processor requires one input flow and can generate only one output flow.

Properties to configure to perform operations on your Number fields.

Configuration
Property	Configuration
Function name	Round value using halfUp mode: Rounds value to the closest number, depending on the precision you set. (3.14 -> 3 and 3.74 -> 4 if Precision is set to 0). Round value using ceil mode: Rounds up value to the nearest number, depending on the precision you set. (3.14 -> 4 if Precision is set to 0, and 3.14 -> 3.2 if Precision is set to 1). Round value using floor mode: Rounds down value to the nearest number, depending on the precision you set. (3.74 -> 3 if Precision is set to 0, and 3.74 -> 3.7 if Precision is set to 1). Round value using down mode: Rounds towards zero. (3.74 -> 3 and -3.74 -> -3 for a Precision set to 0). Remove fractional part: Rounds towards zero. (3.74 -> 3) and (-3.74 -> -3). Compare numbers: Compares this record to another record or a constant. Remove negative values: Replaces negative integers or decimal values with an empty values.
Fields to process	Select the field or fields on which you want to apply a function in the list. Tip noteIf you want to apply the same function to multiple fields at once, click the Open dialog icon to open a tree view that allows you to select multiple fields.
Create new field	Enable this option to create a new field after applying the function. If you do not enable this option, the existing field will be kept and modified.
Rename new field	Give a custom name to the newly created field.

To rename the processor or edit its description, click the Edit Edit icon next to the processor name in the Properties panel.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!