Pivot Table

A pivot table is a data processing technique that rearranges (or "pivots") values from a column to a row to analyze the information in that column.

XMPro provides a convenient Transformation Agent that allows you to pivot your simple, batched 2D data for an in-depth analysis of a specific column.

A summary is generated from a larger data table by first grouping on one or more static columns and then applying an aggregation like count or sum to the pivot column.

Count

Sum

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

This Agent expects to receive batched data.

Pre-requisites

None at this time

Current Version

• Download the Pivot Table Transformation v2.00 (Last Updated 07 Apr 2026)

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

Release Notes

Version	Date	Description
2.00	07 Apr 2026	Support Event-Level Streaming (when using XMPro Platform v4.6+) for reduced memory usage and earlier downstream processing.
1.50	28 Jan 2026	Repackaged to translate the Agent's properties.
1.41	07 Sep 2022	Repackaged to include the Agent's Category
1.40	01 Jul 2020	Incremented version to 2 decimal places
1.38	04 Feb 2020	Changed count column name output so it includes a prefix of the pivot column to be valid for use with other agents
1.37	23 Jan 2020	Initial Release