Numbers functions
Compare numbers
Compares the numbers in the column with a specific value, or values from another column. The function will return TRUE if the condition set by the operator is met, otherwise it will return FALSE.
Properties
| Property | Configuration |
|---|---|
| Columns to process |
Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Comparison operator |
Select the operator to use for the comparison:
|
| Use with |
|
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |
Example
| Input | Configuration | Output |
|---|---|---|
|
|
|
Convert to numbers
Converts the type of data contained in the column so that it is interpreted as numbers in the system.
Properties
| Property | Configuration |
|---|---|
| Columns to process |
Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Decimal separator | Enter a character to act as decimal separator for number data. |
| Thousand separator | Enter a character to act as decimal separator for number data. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |
Remove fractional part
Removes the fractional part of a number to round towards zero.
Properties
| Property | Configuration |
|---|---|
| Columns to process |
Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |
Example
| Input | Output |
|---|---|
|
|
Remove negative values
Replaces negative integers or decimal values with a null value.
Properties
| Property | Configuration |
|---|---|
| Columns to process |
Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |
Example
| Input | Output |
|---|---|
|
|
Round value using ceil mode
Rounds up values to the nearest number, depending on the precision you set.
Properties
| Property | Configuration |
|---|---|
| Columns to process |
Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Precision | Set the number of decimals that you want to keep. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |
Example
| Input | Configuration | Output |
|---|---|---|
| 3.14 |
Precision: 0 |
3 |
| 3.14 | Precision:1 | 3.2 |
Round value using down mode
Rounds a value towards zero.
Properties
| Property | Configuration |
|---|---|
| Columns to process |
Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Precision | Set the number of decimals that you want to keep. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |
Example
| Input | Configuration | Output |
|---|---|---|
| 3.74 |
Precision: 0 |
3 |
| -3.74 | Precision: 1 | -3.7 |
Round value using floor mode
Rounds down value to the nearest number, depending on the precision you set.
Properties
| Property | Configuration |
|---|---|
| Columns to process |
Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Precision | Set the number of decimals that you want to keep. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |
Example
| Input | Configuration | Output |
|---|---|---|
| 3.74 |
Precision: 0 |
3 |
| 3.74 | Precision: 1 | 3.7 |
Round value using half up mode
Rounds value to the closest number, depending on the precision you set.
Properties
| Property | Configuration |
|---|---|
| Columns to process |
Select the column or columns on which you want to apply the function. If you want to apply it on more than one column, use the drop-down list to select which columns, and click Apply. |
| Precision | Set the number of decimals that you want to keep. |
| Create new column | Select this check box if you want to output the result of this function in a new column and keep the original untouched. |
Example
| Input | Configuration | Output |
|---|---|---|
| 3.14 |
Precision: 0 |
3 |
| 3.74 | Precision: 0 | 4 |
| 3.74 | Precision: 1 | 3.7 |
| 3.78 | Precision: 1 | 3.8 |