The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
Converting rows into columns
Hello
I have created the sums of three columns using the aggregate operator. RM shows the sums in a one-row data structure with three new attributes as sum(attr1), sum(attr2), sum(attr3). I want to display the sums in a bar chart and therefore convert the results into a two column data structure with three rows - the first column storing the labels for the x-axis and the second column storing the sums for the y-axis. How can I transfer a one-row data structure like attr1, attr2, attr3 to a three row / two column data structure like
Label1 | attr1
Label2 | attr2
Label3 | attr3
?
Thanks in advance!
0
Answers
Hi,
the Transpose operator should do the job.
Best,
Martin
Dortmund, Germany