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	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

Output True('0') =

Year	Revenue
2018	1
2019	1
2020	1