Options

Can you transpose a selection of the data in RM, the transpose operator is for the whole dataset?

2016004120160041 Member Posts: 6 Newbie
in Help
This is a sample of the current form of the data
SID 5523Course 1C
SID 5523Course 2D+
SID 5523Course 3B-
and the objective is to transform as follows
 Course 1Course 2Course 3
SID 5523CD+B-
Appreciate your help on this.

Answers

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,511 RM Data Scientist
    Hi,
    you want to use the Pivot operator.

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • Options
    IngoRMIngoRM Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University Professor Posts: 1,751 RM Founder
    Hi,
    Martin is right.  You may also want to give Pivot in Turbo Prep a try: https://academy.rapidminer.com/learn/video/turbo-prep-data-pivoting
    Cheers,
    Ingo
  • Options
    sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    edited January 2019
    I now use Turbo Prep every time I need to pivot:

    1. Scott loads data file
    2. Scott does his usual ETL nonsense and realizes he needs to pivot
    3. Scott right-clicks on the output port and jumps to Turbo Prep



    4. Scott drag-and-drops stuff inside TP's pivot tool until he gets what he wants
    5. Scott inserts thing back in to my process and keeps on truckin'.

    That right-click TP jump is life-changing for an ETL geek like myself.

    Scott

Sign In or Register to comment.