Grouping records is a common need when analyzing or reporting data. Organizing records into logical groups often makes it easier to summarize and present data. Logical groups refer to data organized by categories such as; Date, Employee types, Book authors, Music genres, and many others.
Grouped data is formed by aggregating individual observations of a variable into groups. The frequency distribution of these groups serves as a convenient means of summarizing or analyzing the data.
In Synatic, there is a Group step to help with this task. You can group values in multiple records into a single array by grouping the records according to the values in one or more unique key fields.
Adding the Group Mapper Step
To add a Group 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 the Group step as shown in the image below.
Configuring the Group Mapper Step
Illustrated in the below image is the configuration that is available in the Group Mapper step.
ID Fields - Enter the key ID field to identify the record. The Group Mapper step will categorize records based on the defined ID Fields with the same value in the dataset.
Using the Group Mapper Step
The image below shows the original data used in the Record Generator Step.
The image below shows the Group Mapper step Configuration. In this example, the records are grouped according to 'Company' and 'Availability'.
The image below shows the data after the Group Mapper step. Records are grouped according to 'Company' and 'Availability'. These are shown in the 'id' field.
