Skip to main content
Skip table of contents

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

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.