coalesce

Returns the first non-null value from its arguments.

Spec

coalesce(arg0, arg1, ...)

Parameters

arg0, arg1, ... - Two or more arguments of the same type.

Return Value

The first non-null argument value, or null if all arguments are null.

Example

datatable(a:string, b:string)["hello", "world"]
| extend result = coalesce(a, b)

a	b	result
hello	world	hello