Comment on page
Example
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.
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.
Select the Agent and click Configure. In this case, keep the default Collection.
Tick to group the output payload by one or more columns. There is no grouping in our example.
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.
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.
File | Link | Security Key |
|---|---|---|
Data Stream | Concatenate Row Values.xuc | C0mp|ex123 |
Sample Data | AssetsContext.csv | |
Last modified 5mo ago