SplitColumn
This operator splits a column into multiple columns
Operator usage in easy mode
Click + on the parent node.
Enter the wording Split Column in the search field under
What do you want to automate?
and select the Split Column 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 list of columns to split. You can add multiple columns using comma-separated values.
In the Split Regex drop-down, enter the specific Regex on which a column is to be split.
Regex (Regular expression) is a sequence of characters that specifies a search pattern in the text. Used by string-searching algorithms for "find" or "find and replace" operations on strings, or for input validation.
In the Output Column, click
+ Add more
and name the respective output columns in which split values from the input column will be stored.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
splitColumn(table, inputColumn, splitRegex, outputColumns)
table
(TableReference): The input tableinputColumn
(ColumnReference): The name of the column from the input table which needs to be splitsplitRegex
(String): The regex on which a column is to be splitoutputColumns
(String[]): The name of the output columns in which split values from the input column will be stored
Example
Input
isEmployee | salary | designation | |
---|---|---|---|
true | 2986 | HR | |
false | 2986.7910022 | Banker | |
null | 3982 | IT | |
true | 293782 | Media |
You can extract the values using the below query in LQL.
LQL Command
splitColumn(nodeData1, $.email, "@", ["name","domain"])
Output
isEmployee | salary | designation | name | domain | |
---|---|---|---|---|---|
true | 2986 | HR | Chadwick_Ainsworth9303 | ||
false | 2986.7910022 | Banker | Aeris_Bristow8797 | ||
null | 3982 | IT | mathew | ||
true | 293782 | Media | john |