Converting rows into columns

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

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!

Answers

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

    Hi,

     

    the Transpose operator should do the job.

     

    Best,

    Martin

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