CoalesceColumns
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 tableinputColumns
(ColumnReference[]): List of input columns to be coalescedoutputColumn
(String): Output column name
Example
Input
isEmployee | salary | designation | |
---|---|---|---|
true | 2986 | HR | |
false | 2986.7910022 | Banker | |
null | null | 3982 | IT |
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
isEmployee | salary | designation | output | |
---|---|---|---|---|
true | 2986 | HR | ||
false | 2986.7910022 | Banker | ||
null | null | 3982 | IT | 3982 |
true | 293782 | Media |