Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Pivot with multiple group attributes
hanni_euler
Member Posts: 2 Contributor I
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
-
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.