Lookup output AS as parameter
Posted: Thu Jan 12, 2012 12:49 am
I have a lookup table which has a structure like this:
hen I lookup onthe table a.txt, the output is Ref_a.txt. I want to use this value as a parameter and pass it to a seq file stage which will fetch the data from actual file present in a directory whose name is Ref_a.txt. Pls suggest me how to handle this. Thank you
Code: Select all
Ref_File Master_File
---------- -------------
a.txt Ref_a.txt
b.txt Ref_b.txt
c.txt Ref_c.txt