SIGNUM
Basic Overview
Description | Extracts the sign of a number. Positive numbers become 1, negative -1 and zero remains 0. |
Syntax | SIGNUM(Node) |
Parameter |
|
Example
Input A =
Year | Product | Value |
|---|---|---|
2019 | Car | -1 |
2019 | Truck | 3 |
2020 | Car | 0 |
2020 | Truck | -8561451155 |
2023 | Car | 65452141023 |
Output SIGNUM('A') =
Year | Product | Value |
|---|---|---|
2019 | Car | -1 |
2019 | Truck | 1 |
2020 | Car | 0 |
2020 | Truck | -1 |
2023 | Car | 1 |