Combine Datasets with more than one 'label' attribute but retains both 'label' attribute

Emily_123

Hi!

I was wondering whether Rapidminer has an operator that can combine two datasets with two different 'label' attributes but retains both 'label' attribute in the new dataset.  Most blending operators only retain the 'label' attribute of the first dataset.  I have an ID for both data sets that are the same.

 

My data looks like this:

ID       Qty A (label)        Prediction Qty A        

A           2                                    3                      

B           4                                    3.5                     

 

I want to combine it with this:

ID      Qty B (label)       Prediction Qty B              

 B           7                                6.5                           

 A           6                                6.5                          

 

I want the new dataset to look like this

 

ID   Qty A (label)     Prediction Qty A        Qty B (label)       Prediction Qty B             

A         2                              3                           7                           6.5

B         4                              3.5                       6                             6.5

 

 

 

Thank you!                           

 

 

 

MartinLiebig

Hey,

 

sure you can. Since roles need to be unique, you would need to set the role of your attribute to something like label_1 and label_2 and then join afterwards.

 

~Martin