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.

👍 Additional Information

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 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

Example

Input

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

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

LQL Command

splitColumn(nodeData1, $.email, "@", ["name","domain"])

Output

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

Browser not supported