Skip to main content
Version: 2.3.8

Split

Split transform plugin

Description​

Split a field to more than one field.

Options​

nametyperequireddefault value
separatorstringyes
split_fieldstringyes
output_fieldsarrayyes

separator [string]​

The list of fields that need to be kept. Fields not in the list will be deleted

split_field[string]​

The field to be split

output_fields[array]​

The result fields after split

common options [string]​

Transform plugin common parameters, please refer to Transform Plugin for details

Example​

The data read from source is a table like this:

nameagecard
Joy Ding20123
May Ding20123
Kin Dom20123
Joy Dom20123

We want split name field to first_name and second name, we can add Split transform like this

transform {
Split {
source_table_name = "fake"
result_table_name = "fake1"
separator = " "
split_field = "name"
output_fields = [first_name, second_name]
}
}

Then the data in result table fake1 will like this

nameagecardfirst_namelast_name
Joy Ding20123JoyDing
May Ding20123MayDing
Kin Dom20123KinDom
Joy Dom20123JoyDom

Changelog​

new version​

  • Add Split Transform Connector