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 a step to pull out the source data. Select Group 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.

The following icons are used to add, edit, and remove fields:

⨁ - Click to add a new field.
🖊 - Click to edit the current field.
⊝ - Click to remove the current field.
✔ - Click to accept a new field.
⨂ - Click to remove the field being entered.

Example

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.

Useful Tutorials

See the Group tutorial.

Revisit the Getting Started page for a refresher.