| # FieldMapper |
| |
| > FieldMapper transform plugin |
| |
| ## Description |
| |
| Add input schema and output schema mapping. |
| |
| ## Options |
| |
| | name | type | required | default value | |
| |--------------|--------|----------|---------------| |
| | field_mapper | Object | yes | | |
| |
| ### field_mapper [config] |
| |
| Specify the field mapping relationship between input and output |
| |
| ### common options [config] |
| |
| Transform plugin common parameters, please refer to [Transform Plugin](common-options.md) for details. |
| |
| ## Example |
| |
| The data read from source is a table like this: |
| |
| | id | name | age | card | |
| |----|----------|-----|------| |
| | 1 | Joy Ding | 20 | 123 | |
| | 2 | May Ding | 20 | 123 | |
| | 3 | Kin Dom | 20 | 123 | |
| | 4 | Joy Dom | 20 | 123 | |
| |
| We want to delete `age` field and update the field order to `id`, `card`, `name` and rename `name` to `new_name`. We can add `FieldMapper` transform like this |
| |
| ``` |
| transform { |
| FieldMapper { |
| plugin_input = "fake" |
| plugin_output = "fake1" |
| field_mapper = { |
| id = id |
| card = card |
| name = new_name |
| } |
| } |
| } |
| ``` |
| |
| Then the data in result table `fake1` will like this |
| |
| | id | card | new_name | |
| |----|------|----------| |
| | 1 | 123 | Joy Ding | |
| | 2 | 123 | May Ding | |
| | 3 | 123 | Kin Dom | |
| | 4 | 123 | Joy Dom | |
| |
| ## Changelog |
| |
| ### new version |
| |
| - Add Copy Transform Connector |
| |