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

Download

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

Last updated