This operator splits a column into multiple columns
- 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 moreand 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.
splitColumn(table, inputColumn, splitRegex, outputColumns)
table (TableReference): The input table
inputColumn (ColumnReference): The name of the column from the input table which needs to be split
splitRegex (String): The regex on which a column is to be split
outputColumns (String): The name of the output columns in which split values from the input column will be stored
You can extract the values using the below query in LQL.
splitColumn(nodeData1, $.email, "@", ["name","domain"])
Updated over 1 year ago