This operator is used to take the first non-NULL value among the columns provided.

Operator Usage in Easy Mode

Click + on the parent node.
Enter the wording CoalesceColumns in the search field under What do you want to automate? and select the CoalesceColumns operator from the Results to open the operator form.
In the Input Table drop-down, enter or select the table containing the data to run this operator on.
In the Input Column drop-down, enter or select the input columns that are to have coalesced.
In the Output Column name the respective output column in which the first column of non-NULL value will be populated.
Click Run to view the result.
Click Save to add the operator to the playbook.
Click Cancel to discard the operator form.

Usage Details

LQL command

coalesceColumns(table, inputColumns, outputColumn)

table (TableReference): The input table
inputColumns (ColumnReference[]): List of input columns to be coalesced
outputColumn (String): Output column name

Example

Input

email	isEmployee	salary	designation
Chadwick_Ainsworth9303@supunk.biz	true	2986	HR
Aeris_Bristow8797@famism.biz	false	2986.7910022	Banker
null	null	3982	IT
john@gmail.com	true	293782	Media

You can extract the values using the below query in LQL node.

LQL Command

coalesceColumns(nodeData2, ["email","isEmployee","salary","designation"], "output")

Output

email	isEmployee	salary	designation	output
Chadwick_Ainsworth9303@supunk.biz	true	2986	HR	Chadwick_Ainsworth9303@supunk.biz
Aeris_Bristow8797@famism.biz	false	2986.7910022	Banker	Aeris_Bristow8797@famism.biz
null	null	3982	IT	3982
john@gmail.com	true	293782	Media	john@gmail.com

Browser not supported