Group & Merge
Grouping a dataset applies a partition based on one or more columns, which results in one row for each group.
XMPro provides a convenient Transformation Agent that allows you to first group by the specified column(s) i.e. the outgoing payload is a single event per identifier. And secondly, merge the data of the non-grouping columns: the data point is taken from the first event received in the batch where that column is not null.
This is useful when your data consists of batched events, where each event has data for a different column.
Details for an example and its configuration can be found in the How to Use section.
Pre-requisites
None at this time
Current Version
Download the Group & Merge Transformation v2.00 (Last Update: 13 Apr 2026)
Please contact XMPro if you're looking for an older version of this Agent.
Release Notes
2.0
13 Apr 2026
Repackaged to translate missed dropdown properties. Support Event-Level Streaming (when using XMPro Platform v4.6+) for reduced memory usage and earlier downstream processing.
1.01
06 Sep 2022
Repackaged to include the Agent's Category
1.0
24 Sep 2020
Initial Release
Last updated
Was this helpful?