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
Download
Please contact XMPro if you're looking for an older version of this Agent.
Last updated
