Info |
---|
The Create Record transformation plugin is available in the Hub (Hierarchy Plugins). |
Transform plugin generates hierarchical structures from flat schemas. You can use it to collapse flat data into structures.
Configuration
Property | Macro Enabled? | Description |
---|---|---|
Mapping | Yes | Required. Specifies the mapping for generating the hierarchy. |
Include fields missing in mapping | Yes | Required. Specifies whether the fields in the input schema that are not part of the mapping, should be carried over as-is. Default is No. |
Example
Let’s say we have two following data structure:
Field | Type |
---|---|
customer_id | Int |
customer_profile | Record |
– customer_name | String |
– customer_phone | String |
order_id | Int |
product_id | Int |
amount | Double |
order_description | String |
By setting the following mapping:
...
It will create target model will look like this:
Field | Type |
---|---|
customer_id | Int |
– name | String |
– phone | String |
orders | Record |
– id | Int |
– product_id | Int |
– amount | Double |
– description | String |