Hi All,
In one part of my job design I have a snippet of data in the below format:
Table1:
Col1 Col2 Col3
100 2000 1
101 2001 1
102 2002 1
103 2002 1
Table2:
Col1 Col2
1 DK
2000 9200
2001 9300
2002 9400
Target Should be:
Col1 Col2 Col3
100 9200 Dk
101 9300 Dk
102 9400 Dk
103 9400 Dk
I was trying to do a lookup using col3 in table 1 to col1 in table 2 first and then col2 in table1 to col1in table2.
But was unable to get the expected result.
Any ideas or help is greatly appreciated.
Look-Up for a Complex Logic
Moderators: chulett, rschirm, roy
Look-Up for a Complex Logic
Thanks,
Pavan
Pavan
Re: Look-Up for a Complex Logic
pavans wrote:Hi All,
In one part of my job design I have a snippet of data in the below format:
Table1:
Col1 Col2 Col3
100 2000 1
101 2001 1
102 2002 1
103 2002 1
Table2:
Col1 Col2
1 DK
2000 9200
2001 9300
2002 9400
Target Should be:
Col1 Col2 Col3
100 9200 Dk
101 9300 Dk
102 9400 Dk
103 9400 Dk
I was trying to do a lookup using col3 in table 1 to col1 in table 2 first and then col2 in table1 to col1in table2.
But was unable to get the expected result.
Any ideas or help is greatly appreciated.
I have got the logic.
Thanks,
Pavan
Pavan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: