Transpose Transformation Agent Example - Columns - XMPRO Data Stream Designer

Follow this step-by-step example to configure the Transpose 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

transpose agent to convert granular

columns into a row per asset and

parameter

first drag the agent onto the canvas

link the input to the stream data and

output to clean name

rename the agent

save the data stream and click on the

agent to configure it

change the type to columns

keep the date

add a transposed column for sensor 1 tag

1 its name is transposed to crusher and

value to tag 1 column

add another for sensor 1 tag 2 named

crusher

and value in the tag 2 column

add another for sensor 2 tag 1 named

crusher and value in the tag 1 column

last one for sensor 2 tag 2 named

crusher

and value in the tag 2 column

apply the changes

save the data stream

publish it and let's look at the live

data view

the event is split into a row per

transposed column that includes the

static column the transposed columns

header value and null value for other

transposed columns

the calculated field is handy to remove

tag in the asset name and the group and

merge to collapse the null values

resulting in one row per asset

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