SplitColumn

This operator splits a column into multiple columns

Operator usage in easy mode

1. Click + on the parent node.

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

3. In the Input Table drop-down, enter or select the table containing the data to run this operator on.

4. In the Input Column drop-down, enter or select the list of columns to split. You can add multiple columns using comma-separated values.

5. In the Split Regex drop-down, enter the specific Regex on which a column is to be split.

7. In the Output Column, click + Add more and name the respective output columns in which split values from the input column will be stored.

8. Click Run to view the result.

9. Click Save to add the operator to the playbook.

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

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

LQL Command

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

Output