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, "no-email@example.com")

Output:

"alice@example.com"

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.