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 =

YearProductRevenue
2018A95
2019

B

-56
2020A107
2020B5

Output TRUE('DecimalNode'+'Products') =

YearRevenue
20181
20191
20201

A =

YearRevenue
201859
2019
2020157

Output TRUE('A') =

YearRevenue
20181
2019
20201

Output True('0') = 

Year
Revenue
20181
20191
20201

JavaScript errors detected

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

If this problem persists, please contact our support.