Why does the Split operator not keep the values?

SylvainM

Hello everyone,

As usual, I have quite a simple task to do but I haven't found an easy answer to it yet.


Let's say I have that Example Set:

Sale	Clients	Product
A	x	CCD
B	x ; y	CCD
C	y	CS
D	y	CCD
E	x ; z	DU
F	x ; y ; z	CS
G	y ; z	DU

And I want to split it to get that new Example Set: 

Sale	Clients	Product
A	x	CCD
B	x	CCD
B	y	CCD
C	y	CS
D	y	CCD
E	x	DU
E	z	DU
F	x	CS
F	y	CS
F	z	CS
G	y	DU
G	z	DU

What I thought first was: "Hey! You can do that! Let's do a Transpose, then a Split, and a Transpose again!" But this is what I get:

Sale	Clients	Product
?	y	?
?	z	?
?	y	?
?	z	?
?	z	?
A	x	CCD
B	x	CCD
C	y	CS
D	y	CCD
E	x	DU
F	x	CS
G	y	DU

Why did the Split operator not keep the values associated to the split examples? And what can I do to keep them?

I'm sorry if my question is obvious: I'm still exploring RapidMiner

Thanks a lot and best to all,
Sylvain

SylvainM

Hello Ingo,

Your solution works perfectly well! It is short and clear, as I like

Thank you soooo much! I'm learning a lot with you help.

Best,
Sylvain