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 |