...
- keyField: key on the basis of which input record will be denormalized. This field should be included in input schema.
- fieldNamenameField: Name of the field in input record that contains output fields to be included in denormalized output.
- fieldValuevalueField: Name of the field in input record that contains values for output fields to be included in denormalized output.
- outputFields: List of the output fields to be included in denormalized output.
- fieldAliases: List of the output fields to rename. The key specifies the name of the field to rename, with its corresponding value specifying the new name for that field.
...
{
"name": "RowDenormalizer",
"type": "batchaggregator",
"properties": {
"outputFields": "FIRST_NAME,LAST_NAME,Address,City",
"fieldAliases": "Address:Addr",
"keyField": "Key Field",
"fieldNamenameField": "Field Name",
"fieldValuevalueField": "Field Value"
}
}
The transform takes Database table as input record that has a Key Field, Field Name, Field Value input fields specified by user, denormalizes it on the basis of the key field, and then returns a denormalized table according to the output schema specified by the user.
...