NullToZero 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 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 0, col2 is 0, and col3 is 999.

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