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 agent to group inventory data by
product type and price and pivot the
quantity column values
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
count the values
tick for a total column and enter the
values to pivot
apply the changes
save the data stream
publish it
and let's look at the live data view
each batch of events is collapsed to one
row per product type and price
with columns for each pivoted value from
the incoming quantity column
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
