Grouper

The Grouper is used to group data based on specific criteria or field values, allowing for the aggregation or segmentation of data into logical subsets. Its key applications include:

1. Data Grouping: Organizes data into distinct groups based on one or more fields, simplifying analysis.
2. Aggregation: Facilitates aggregation operations (e.g., sum, average) within each group, making it easier to derive insights.
3. Data Segmentation: Divides data into categories or segments for targeted processing or reporting.
4. Efficient Processing: Reduces complexity by processing data in smaller, more manageable groups rather than as a whole.
5. Enhanced Reporting: Improves reporting by organizing data into meaningful categories that can be analyzed separately.

This transformation is essential for scenarios where understanding patterns, trends, or summaries across groups of data is needed.

Properties

To change Grouper properties double click on the object. Choose appropriate grouping order and grouping type. Fields with grouping type Ignore are not passed to the next object.

Grouping types

• Ignore
• Group By
• First Value
• First Non Empty Value
• Last Value
• Last Non Empty Value
• Avg
• Min
• Max
• Sum
• Count
• Concatenate
• Concatenate Unique