TRUE
Basic Overview
Please note that TRUE will only return a 1 for every defined row in the input. If you need a 1 for each undefined row, look at the IS_NA function.
Description | Returns true (1) for every defined value in the input. |
Signature | TRUE(Node) |
Parameters |
|
Example
DecimalNode =
Year | Revenue |
2018 | -24.5 |
2019 | 95 |
2020 | 110 |
Output TRUE('DecimalNode') =
Year | Revenue |
2018 | 1 |
2019 | 1 |
2020 | 1 |
Products =
Year | Product | Revenue |
2018 | A | 95 |
2019 | B | -56 |
2020 | A | 107 |
2020 | B | 5 |
Output TRUE('DecimalNode'+'Products') =
Year | Revenue |
2018 | 1 |
2019 | 1 |
2020 | 1 |
A =
Year | Revenue |
2018 | 59 |
2019 | |
2020 | 157 |
Output TRUE('A') =
Year | Revenue |
2018 | 1 |
2019 | |
2020 | 1 |