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.
.png?alt=media&token=e751c10a-63cc-440c-853c-72d07ad3f10b)
This is useful when your data consists of batched events, where each event has data for a different column.
Pre-requisites
None at this time
Download
Name
Link
Group & Merge Transformation v1.0
Last modified 4mo ago
Copy link