TRUE

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

  • Node: Input node, specified using the node name in single quotes (e.g. 'Profit')

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

Was this helpful?

Yes | Somewhat | No