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.

TABLE JOIN & PIVOT PROBLEM IN USE CASE

sjkangsjkang RapidMiner Certified Analyst, Member Posts: 2 Contributor I
edited December 2018 in Help

I want to make a table like this..

We have 2 tables.

 

COL1 COL2 COL3 COL4 COL5
M1 L1 01 PARA1,PARA2,PARA3,PARA4 1.0,1.1,1.2,50.3
M1 L1 02 PARA1,PARA2,PRAR3 5.4,3.4,2.3
M2 L2 01 PARA2,PARA3,PARA5,PARA6 1.1,2.2,3.3,4.4
M2 L2 02 PARA7,PARA8,PARA9,PARA2 3.3,4.4,5.5,6.6

 

COL1 COL2 COL3 COL4 COL5
M1 L1 01 OP1_PARA1 5.6
M1 L1 02 OP1_PARA2 4.5
M2 L2 01 OP2_PARA1 4.5
M2 L2 02 OP2_PARA2 5.6

 

COL1, COL2, COL3 : Unique Index

COL4, COL5  PARA and Value are matched, respectively

 

When we pivot using 2 tables, aggregation function is AVG or MEDIAN.

 

Final goal is to make a one table like this format.

COL1   COL2   COL3  PARA1   PARA2  PARA3  PARA4  PARA5  PARA6 PARA7 PARA8  PARA9  OP1_PARA1  OP2_PARA2 OP2_PARA1 

OP2_PARA2

 

what kind operator we can use it...?

Best Answer

  • lionelderkrikorlionelderkrikor RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    Solution Accepted

    Hi @sjkang,

     

    Hi @sjkang

     

    Can you with an excel file, be extremely to be very precise....

    and with an excel file (ot not) define exactly what you want to obtain ?

     

    Thanks you

     

    Regards

     

    Lionel

Answers

  • lionelderkrikorlionelderkrikor RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn

    Hi @sjkang,

     

    Could you be more explicit ?

     

     

  • sjkangsjkang RapidMiner Certified Analyst, Member Posts: 2 Contributor I

    Hi  lionelderkrikor

     

    Thank you for your interest.

    I already solve this problem!

     

    Thank!

     

    SJ

     

  • lionelderkrikorlionelderkrikor RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn

    Hi @sjkang,

     

    Congratulations !

     

    Good continuation,

     

    Regards,

     

    Lionel

Sign In or Register to comment.