XMPro Transpose Agent – Data Transformation & Setup Guide

Learn how to use the XMPro Transpose Agent to transform asset data by converting rows to columns or columns to rows.

Overview

The XMPro Transpose Agent is a data transformation tool that allows you to convert rows to columns or columns to rows within your data streams. Use this agent to restructure asset and parameter data for downstream analytics, reporting, or integration with other XMPro agents.

For simple use cases, see the Transpose Transformation Agent Examples.

For a detailed configuration guide, see the Transpose Transformation Agent Configuration.

Rows to Columns

When your data is received by row per parameter for all assets; this Agent converts the rows to columns so that a row per asset (with multiple parameters as columns) is pushed downstream.

In this example, the data is first grouped by Date and SensorClass. Then the SensorType row data becomes the transposed column names and the Value row data becomes the transposed column values. The static columns appear in the output, unchanged.

Columns to Rows

When your data is received by row for all assets and parameters; this Agent converts the columns to rows such that each row in the input payload is split into a row per asset and transposed parameter column. The output consists of the following:

• The (unchanged) static column(s)

• The transposed column's header as a value under a new column name

• The transposed column's value under a new value name

• Null values for all other columns to be transposed, under their respective new value name

In this example, there is a row per timestamp and a column per asset name/parameter. We want to transpose this to a row per asset with columns for the asset name, parameter Tag1 and parameter Tag2.

On the agent, a grid is populated with an instruction per column to transpose. We specify that for column SC1_Tag1, the column name is the value of a new column Crusher and the column value is the value of a new column Tag1Column. Likewise for the other asset/parameter columns.

The result is a row per asset and transposed column, with null values for the other transposed columns.

The Calculated Field Transformation is handy to remove the "_Tag" of the asset name; and the Group & Merge Transformation to collapse the null values, i.e. one row per asset.

Current Version

• Download the Transpose Transformation v1.12 (Last Updated 27 May 2025)

• Additional Prerequisites: None

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

Transpose Release Notes

Version	Date	Description
1.12	27 May 2025	Repackaged to translate the Agent's properties. Added "Multiple Column Transpose" to simplify the common columns transpose configuration when all the transposed columns will have the same column and value. When ticked, enter a single column name and value rather than completing the same for all columns to transpose. Exclude the Static Columns from the transpose options.
1.09	30 Nov 2023	Fixed an error in the Integrity Check.
1.08	15 Jun 2023	Fixed an error in the Integrity Check.
1.07	07 Sep 2022	Repackaged to include the Agent's Category.
1.06	23 Sep 2020	Fixed issue with Stream host memory spike by removing redundant grouping and allowing grouping by multiple columns.
1.04	24 Aug 2020	Fixed static columns issue.
1.03	21 Aug 2020	Added support for no groupings.
1.02	13 Jul 2020	Fixed Static Columns to not be required for the Agent to work.
1.00	30 Apr 2020	Initial Release.