blob: ad3c3de1918b58f8514ff6486b7b6aec4f621524 [file] [log] [blame] [view]
# 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