This example Data Stream demonstrates how to use this Transformation to concatenate batched pump asset numbers into a comma-separated list. The asset list could be further formatted and used to filter contextual data.

Refer to configuration to understand all configuration options of this Agent.

Step 1: Add the Agent

Drag the Concatenate Row Value Agent onto the canvas and link the input endpoint to the pump data and the output to the printer. Rename the Agent and save the Data Stream.

Step 2: Configure General

Select the Agent and click Configure. In this case, keep the default Collection.

Step 3: Configure Grouping

Tick to group the output payload by one or more columns. There is no grouping in our example.

Step 4: Configure Input

Click the add (+) button, select a column, enter an alias, and apply the changes.

In this case, set the column to PumpId, the alias to AssetList, and use a comma as the separator.

Step 5: Results

Save the Data Stream and publish it.

Let's look at the Live Data View. Observe that the batch of 6 incoming events has been transformed into a single event.


See the Import, Export, and Clone - XMPro article for steps to import a Data Stream.

Last updated