Conditional / Null Handling Functions
7 functions for null coalescing, CASE WHEN logic, and list membership checks. The source column is always the implicit first input.
| Function | Syntax | Parameters | Notes |
|---|---|---|---|
if_null / coalesce | if_null(column, fallbacks[]) | fallbacks — ordered array of operands. Legacy single defaultValue also supported. | Returns the first non-null value across column and fallbacks. |
null_if | null_if(column, value) | value — comparison value. | Returns null when column equals value, otherwise the column. |
case_when | case_when(branches[], elseValue) | branches — ordered array of {left, operator, right, then}. elseValue — fallback result. | General multi-branch conditional; see also the dedicated Case When transformation node for single-column builders. |
in_list | in_list(column, values[]) | values — array of literal values. | Returns boolean. |
not_in_list | not_in_list(column, values[]) | values — array of literal values. | Returns boolean. |
is_null | is_null(column) | None. | Returns boolean. |
is_not_null | is_not_null(column) | None. | Returns boolean. |