Nested Searching

[risabhroy_03]

Hey,

I have 2 columns named AQPART and AQMTLP.

I want to search for my AQMTLP value in AQPART and want to print the corresponding value of AQMLTP.

For ex - I want to search MTLA42671 from AQMLTP in AQPART and I want to print the corresponding AQMLTP value for that.

Please help.

[edwin]

load your table as a mapping table then use applymap:

load mapping table1:
load AQPART,AQMTLP
....from....;

load applymap('table1', AQMTLP,'NOT FOUND') as newfield
....from....;

you can then decide what to do if newfield is NOT FOUND