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

Name
Link
Group & Merge Transformation v1.0
Download
Last modified 4mo ago
Copy link