IsNotNull function

Returns true when an expression does not evaluate to the null value.

Namespace

Global. No namespace qualifier required.

Input

any object or expression

Output

boolean (true/false)

Example

If a contains the null, b contains string value and c contains number 999 then If the input column does not contain a null, the output column contains the value of the input column. If the input column does contain a null, then the output column contains the string null. In the below examples, col1 is null, col2 is value, col3 is 999 and col4 is null.

set-column col1 IsNotNull(a) ? a : null
set-column col2 IsNotNull(b) ? b : null
set-column col3 IsNotNull(c) ? c : null
set-column col4 if(IsNotNull(c)) { a } else { b }