Converting rows into columns

dg34522dg34522 Member Posts: 1 Contributor I
edited November 2018 in Help



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!


  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 RM Data Scientist



    the Transpose operator should do the job.




    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.