Examples

The following examples can be found on this page:

• Count Aggregation

• Sum Aggregation

Count Aggregation

An example Data Stream can be found below that demonstrates how to use this Transformation to group inventory data by product type and price, and pivot the quantity column values.

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

Files

File	Link	Security Key
Data Stream	Pivot Table (Count).xuc	C0mp|ex123
Sample Data	PivotData.csv

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

Sum Aggregation

An example Data Stream can be found below that demonstrates how to use this Transformation to group inventory data by product type and price, and add quantity to a new column named 'Generated'.

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

Files

File	Link	Security Key
Data Stream	Pivot Table (Sum).xuc	C0mp|ex123
Sample Data	PivotData.csv

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