Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.

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

2016004120160041 Member Posts: 6 Learner I
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

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

    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
  • IngoRMIngoRM 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
  • 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.