Loopup Using Lookup file set
Posted: Thu Jun 26, 2008 1:01 am
Hi All,
Should the key column of Loopup file set and the main input be same?
I am having a column called Cust_Id Varchar(10) as the key in Main Link.
In Lookup file set am having the Key column as DOC_Id Varchar(10).
Am not able to loopup with these as the key columns
If the key column name is different is it not possible to use the lookupfile set? so do we need to use Seq file as the loopup?
Please clear my doubt.
Thanks,
SenthilP
Should the key column of Loopup file set and the main input be same?
I am having a column called Cust_Id Varchar(10) as the key in Main Link.
In Lookup file set am having the Key column as DOC_Id Varchar(10).
Am not able to loopup with these as the key columns
If the key column name is different is it not possible to use the lookupfile set? so do we need to use Seq file as the loopup?
Please clear my doubt.
Thanks,
SenthilP