Description
Returns the first non-NULL argument.Syntax
COALESCE(expression1, expression2 […,expressionN])
Examples
COALESCE(field1, field2, field3)
Return the first non-null argument from a list of expressions. Use COALESCE for null handling and providing default values in ETL pipelines.
COALESCE(expression1, expression2 […,expressionN])
COALESCE(field1, field2, field3)