Follow this step-by-step example to configure the Pivot Table Transformation Agent in the XMPro Data Stream Designer.
Need help with creating your XMPRO Data Streams? Visit https://documentation.x... this example demonstrates how to use the
pivot table agent to group inventory
data by product type and price and some
quantity to a new column generated
first drag the agent onto the canvas
link the input to the batch data and
output to the printer
save the data stream
and click on the agent to configure it
we'll group by product type and price
pivot on quantity
and sum its values
apply the changes
save the data stream
publish it and let's look at the live
data view
the batch of events are collapsed to one
row per product type and price with the
new generated column added
you can download the files below to try
them out yourself and for more
information about this agent's
properties head to the configuration
page thank you
