Look-Up for a Complex Logic

[pavans]

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.

[pavans]

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.

[chulett]

Care to post it? Would help future searchers with the same question.

[ray.wurlod]

Apart from the change of case it looks like an ordinary, regular, key-based lookup to me.

[chulett]

Shhhhhhh....