Split
Split transform plugin
Description
Split a field to more than one field.
Options
name | type | required | default value |
---|---|---|---|
separator | string | yes | |
split_field | string | yes | |
output_fields | array | yes |
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:
name | age | card |
---|---|---|
Joy Ding | 20 | 123 |
May Ding | 20 | 123 |
Kin Dom | 20 | 123 |
Joy Dom | 20 | 123 |
We want split name
field to first_name
and second name
, we can add Split
transform like this
transform {
Split {
plugin_input = "fake"
plugin_output = "fake1"
separator = " "
split_field = "name"
output_fields = [first_name, second_name]
}
}
Then the data in result table fake1
will like this
name | age | card | first_name | last_name |
---|---|---|---|---|
Joy Ding | 20 | 123 | Joy | Ding |
May Ding | 20 | 123 | May | Ding |
Kin Dom | 20 | 123 | Kin | Dom |
Joy Dom | 20 | 123 | Joy | Dom |
Changelog
new version
- Add Split Transform Connector