跳到主要内容
版本:2.3.2

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