🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Pivot with multiple group attributes

User: "hanni_euler"
hanni_euler
New Altair Community Member
Updated by Jocelyn

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

 

Find more posts tagged with

AI Studio
Pivot + De-Pivot
Sort by:
1 - 1 of 11
    User: "hanni_euler"
    hanni_euler
    New Altair Community Member
    OP
    Accepted Answer

    Thank you for your reply, T-Bone.

     

    I solved it now this way:

    1. Filter for two example sets (1. all Examples with IFC 2. all Examples with FQC).
    2. Rename "Rating" in both exampleSets
    3. Join them with key attributes VIN, part, side, model code, measuring point

     

    Best regards.

    View in context
Quick Links