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

20160041

This is a sample of the current form of the data

SID 5523	Course 1	C
SID 5523	Course 2	D+
SID 5523	Course 3	B-

and the objective is to transform as follows

	Course 1	Course 2	Course 3
SID 5523	C	D+	B-

Appreciate your help on this.

Find more posts tagged with

AI Studio

Accepted answers

All comments

MartinLiebig

Hi,
you want to use the Pivot operator.

Best,
Martin

IngoRM

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

sgenzer

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

Image: https://us.v-cdn.net/6030995/uploads/editor/wb/bzm2yqo5nchu.png

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