pivoting the data
Posted: Tue Jun 17, 2008 4:52 pm
Hi ,
Below is the sample i/p and o/p data that i need to design the data.
I/P1
column1|column2|column3|column4
A 50 51
I/P2
column1|column2|column3|column4
A 1 20 50
A 2 21 50
A 3 22 50
A 1 23 51
A 2 24 51
I/P2
O/P
column1|column2|column3|column4
A 1 20 23
A 2 21 24
A 3 22 ''
NEED TO JOIN TWO I/PS WITH COLUMN1 OF I/P1 AND COLUM2,COLUMN3 OF I/P 1
I tried to design using the join b/w the i/p1 and i/p2 but could not get the o/p as expected.
Let me know if you have any Questions in understanding.
Thanks in advance
Below is the sample i/p and o/p data that i need to design the data.
I/P1
column1|column2|column3|column4
A 50 51
I/P2
column1|column2|column3|column4
A 1 20 50
A 2 21 50
A 3 22 50
A 1 23 51
A 2 24 51
I/P2
O/P
column1|column2|column3|column4
A 1 20 23
A 2 21 24
A 3 22 ''
NEED TO JOIN TWO I/PS WITH COLUMN1 OF I/P1 AND COLUM2,COLUMN3 OF I/P 1
I tried to design using the join b/w the i/p1 and i/p2 but could not get the o/p as expected.
Let me know if you have any Questions in understanding.
Thanks in advance