Concatenate Row Values

Concatenation is a data processing operation that combines multiple pieces of data to create a single, larger, piece of data.

The Concatenate Row Values Transformation allows you to transform an incoming batch into one row, where the values of selected columns are concatenated with the specified separator.

This is useful when your data consists of batched contextual data, where each event has data for a different value that you need to combine into a single value to prepare input for Agents that use an array, such as REST API and Boon Amber.

For example, concatenate a batch of individual asset numbers into a comma-separated list called AssetList. Next, use the Calculated Field Agent to format the value by adding a leading and trailing single quote. Finally, use the resulting string with an 'IN' operand as filter criteria on Agents such as the SAP HANA Action Agent.

Details for an example and its configuration can be found in the How to Use section.

Pre-requisites

This Agent expects to receive batched data.

Current Version

• Download the Concatenate Row Values Transformation v2.00 (Last Update: 14 May 2026)

Please contact XMPro if you're looking for an older version of this Agent.

Release Notes

Version	Date	Description
2.00	14 May 2026	Support Event-Level Streaming (when using XMPro Platform v4.6+) for reduced memory usage and earlier downstream processing. Repackaged to translate the Agent's properties.
1.12	21 Mar 2023	Repackaged to change Agent's category from Function to Transformation
1.1	28 July 2020	Added Group By functionality
1.0	28 July 2020	Initial Release