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.

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

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

Last modified 1yr ago