Loopup Using Lookup file set

[senthilt1]

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

[ray.wurlod]

If it's a Lookup File Set servicing the reference input, then the lookup key column on the stream link must have the same name as the key column defined for the Lookup File Set. You can cheaply achieve a column name change using a Copy stage on the stream input.

[senthilt1]

Hi Ray,

Sorry for disturbing u,,,I am not premium member could you please let me know the solution for this.

My assumption is using the copy stage we can rename the Main link key column such as same as Lookup key column name. Can i go with this approach.

Thanks,

Senthil P

[poornima.chandramouli]

Hi Ray,

Sorry for disturbing u,,,I am not premium member could you please let me know the solution for this.

My assumption is using the copy stage we can rename the Main link key column such as same as Lookup key column name. Can i go with this approach.

Thanks,

Senthil P

Hi Senthil,

The column name should be same while using the Lokkup fileset.
Otherwise you can use a parallel dataset for doing the lookup.

Thanks

[senthilt1]

Thanks Poornima.Chandramouli for your info.

Havent tried it yet, will let you know once it works out.

SenthilP