Pivot Table Transformation Agent Example - Sum - XMPRO Data Stream Designer

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.xmpro.com or send an email to [e-mail].

Visit https://xmpro.com if you want to learn more about how you can build real-time applications with our No-Code Application Composition Platform.

Transcript

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