The Altair Community and the RapidMiner community is on read-only mode until further notice. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options
Pivot with multiple group attributes
![hanni_euler](https://us.v-cdn.net/6030995/uploads/defaultavatar/nCCNNSPK1YM69.jpg)
![](https://s3.amazonaws.com/rapidminer.community/vanilla-rank-images/contributor-16x16.png )
Hi everyone,
I'm new to Rapidminer, so my question might be super easy.
I have a data set with the following Attributes:
- Model Code (identifies a group of cars)
- VIN (identifies cars)
- Part (identifies part of the car: Fender or door)
- Measuring Point (identifies measuring points at the part)
- Station (IFC or FQC -> two times of measurements)
- Rating (Green: 1, Yellow: 2, Red: 3)
I want to get the IFC and FQC rating of one measuring point in one row (--> have 2 new attributes: IFC_Rating & FQC_Rating.
My problem is that the group attribute in the "Pivot" operator can only be one attribute.
What can I do?
Thank you in advance. Johannes
Tagged:
0
Best Answer
-
Options
hanni_euler Member Posts: 2
Contributor I
Thank you for your reply, T-Bone.
I solved it now this way:
- Filter for two example sets (1. all Examples with IFC 2. all Examples with FQC).
- Rename "Rating" in both exampleSets
- Join them with key attributes VIN, part, side, model code, measuring point
Best regards.
1
Answers
Did you take a look at the Aggregate operator too? That allows you to group multiple attributes.