NullToValue function

Returns zero if the input column is null, otherwise returns the input column value.

Namespace

Global. No namespace qualifier required.

Input

Column value (object/expression)

Output

Column value or zero.

Example

If a contains the null, b contains string value, and c contains the 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 42, col2 is 42, and col3 is 999.

set-column col1 NullToValue(a)
set-column col2 NullToValue(b == 'value' ? a : b, 42)
set-column col3 NullToValue(c)