coalesce()
Evaluates a list of expressions and returns the first non-null (or non-empty for string) expression.
coalesce(tolong("not a number"), tolong("42"), 33) == 42
Syntax
coalesce(expr_1, expr_2, ...)
Arguments
- expr_i: A scalar expression, to be evaluated.
- All arguments must be of the same type.
- Maximum of 64 arguments is supported.
Returns
The value of the first expr_i whose value is not null (or not-empty for string expressions).
Example
print result=coalesce(tolong("not a number"), tolong("42"), 33)
| result |
|---|
| 42 |