TABLE JOIN & PIVOT PROBLEM IN USE CASE

sjkang

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...?

lionelderkrikor

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

lionelderkrikor

Hi @sjkang,

 

Could you be more explicit ?

 

 

lionelderkrikor

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

sjkang

Hi  lionelderkrikor

 

Thank you for your interest.

I already solve this problem!

 

Thank!

 

SJ

 

lionelderkrikor

Hi @sjkang,

 

Congratulations !

 

Good continuation,

 

Regards,

 

Lionel