SplitColumn

Splits a column into multiple columns

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.

👍

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.

  1. In the Output Column, click + Add more and name the respective output columns in which split values from the input column will be stored.
  2. Click Run to view the result.
  3. Click Save to add the operator to the playbook.
  4. Click Cancel to discard the operator form.

Usage Details

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
[email protected] true 2986HR
[email protected] false 2986.7910022Banker
[email protected] null 3982IT
[email protected] true 293782Media

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

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

Output

email isEmployee salary designation name domain
[email protected] true 2986HR Chadwick_Ainsworth9303supunk.biz
[email protected] false 2986.7910022Banker Aeris_Bristow8797 famism.biz
[email protected] null 3982IT mathew outlook.com
[email protected] true 293782Media john gmail.com

© 2017-2021 LogicHub®. All Rights Reserved.