Denormalizing or flattening data is a common need in a database when you want to store the data in one or a few tables containing all the information and with little enforcement of structure.
The use of flattened data may be used in analytics programs, graphing, or data warehouses. All the information is just stored in one large table, referred to as a denormalized schema.
In Synatic, there is a Split step to help with this task. You can take multiple arrays and break out the individual records according to the array field values.
Adding the Spit Mapper Step
To add a Sort Mapper step in a flow, follow the below instructions:
1. Click on the highlighted icon as shown in the below image.
2. The below page will appear. Select or search for a step to pull out the source data. Select Split as shown in the image below.
Configuring the Split Mapper Step
Illustrated in the below image is the configuration that is available in the Split Mapper step.
Array Path - Enter the field which identifies the array in the source dataset.
Merge Fields - Add one or more fields that reside outside of the array in the main record, which you want to be merged with the resultant records after denormalizing.
Add item - Click to add fields to merge. Once a field is typed, press the Enter Button to add it.
Example
The image below shows the original data used in the Record Generator Step. It consists of two records each containing a single array of transactions related to each main record.
The image below shows the Split Mapper step Configuration. The field used to uniquely identify each array in the record has the Array Path field name 'Transactions'. Name and Lastname of the record holder from the above input records are added.
The image below shows the data after the Split Mapper step. Records in the Transactions array are split into six records, and the Name and Lastname fields are added.
Useful Tutorials
See the Split tutorial to learn how to configure the step and the basic flow.
Revisit the Getting Started page for a refresher.
Read more about Steps here.