| Table of Contents | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
|
This operator splits a column into multiple columns
...
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.
...
| Code Block |
|---|
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 |