Version: v2.4
FieldSplitter
This node splits the string of the specified input column using the specified delimiter
Input
It accepts a DataFrame as input from the previous Node
Output
New columns are added to the incoming DataFrame with values from the result of splitting the value in the input column
Type
transform
Fields
Name | Title | Description |
---|---|---|
inputCol | Input Column | input column name |
outputCols | Output Columns | new column names separated by comma','.(eg: col1,co2,col3) |
sep | Separator | separator to split the input column value(default: space) |
onError | On Error |
Examples
Input
date_of_payment | total_amount |
---|---|
StringType | DoubleType |
12/17/2013 | 113.48 |
12/4/2013 | 119.49 |
12/16/2013 | 12.01 |
10/22/2013 | 10.61 |
Parameters
Name | Value |
---|---|
Input Column | date_of_payment |
Separator | / |
Output Columns | month,date,year |
Output
date_of_payment | total_amount | month | date | year |
---|---|---|---|---|
StringType | DoubleType | StringType | StringType | StringType |
12/17/2013 | 113.48 | 12 | 17 | 2013 |
12/4/2013 | 119.49 | 12 | 4 | 2013 |
12/16/2013 | 12.01 | 12 | 16 | 2013 |
10/22/2013 | 10.61 | 10 | 22 | 2013 |