COALESCE
First non-empty value
Syntax
COALESCE(a, b)
Example
coalesce({{name}}, {{companyname}})Notes
In the example: If name has a value, return name, else return companyname
COALESCE(a, b)
coalesce({{name}}, {{companyname}})In the example: If name has a value, return name, else return companyname