NullToEmpty function

Returns an empty string if the input column is null, otherwise returns the input column value.

Namespace

Global. No namespace qualifier required.

Input

any object or expression

Output

input value or string

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 '', col2 is value, and col3 is 999.

set-column col1 NullToEmpty(a)
set-column col2 NullToEmpty(b)
set-column col3 NullToEmpty(c)