Merging double attributes and it's examples together

eldenoso

Hello,

I am pretty new to RapidMiner and thus can't find a solution the problem I have. 
My example set contains customer ID's, booking years and the booked hotel. Because within each year some of the customers are going on holiday twice or more, there are double ID's occuring. Is it possible with RapidMiner to somehow merge the belonging booked hotels of the ID's together in one example? To make it more cleary I give you an example of what I mean: 

Raw Data Year 20XX:
ID     BookedHotel

12     Laplaza

13     Greengarden

12     Ocean

15     Laplaza

Now the customer with the ID 12 is going on holiday twice this year. One time to Laplaza Hotel and the other time to the Ocean Hotel. Now what I want to achieve should look like this:

ID     BookedHotel

12     Laplaza; Ocean

13     Greengarden

15     Laplaza

 

So that if a customer books twice or more a year, the hotels are seperated by a semicolon in the same "cell". I already tried to achieve this by Pivot or generate Concatenation, but without success. 

Thank you for your help and sorry for any mistakes (I'm german).

MartinLiebig

Hi eldenoso,

 

Aggregate is doing the job. concat(hotel) and group_by id. The default delimiter is | but you can of course replace it with a Replace operator.

 

~Martin