coalesce

utility

Returns the first non-null value

Syntax

coalesce(values...)

values (any)

Multiple values to check

any

The first non-null value from the arguments

Use first available email

Input:

coalesce(.email, .backup_email, "[email protected]")

Output:

"[email protected]"

Return first non-null value or default to 0

Input:

coalesce(.value1, .value2, .value3, 0)

Output:

The coalesce() function returns the first non-null value from a list of arguments.

Use coalesce() to provide fallback values, handle missing data, or select from multiple potential data sources.