Pivot Table Transfor...

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...

Transcript

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

Last updated