join two keys with lookup stage

vinsashi · Post by **vinsashi** » Mon Oct 17, 2011 10:54 pm

Hi,
i have two fileds in source f1,f2 and in reerence data i have r1,r2 column.
first i should lookup f1 and r1 then for matchinf records i should pass r2 .for unmatching records i should lookup f2 with r1 then i should pass r2 for those records.is this one how can i do with singale lookup stage.

.........

ray.wurlod · Post by **ray.wurlod** » Mon Oct 17, 2011 11:29 pm

Don't do it. Use two Lookup stages. It's cleaner.

vinsashi · Post by **vinsashi** » Tue Oct 18, 2011 1:03 am

will it possible.if itpossible how to do what are the options i should mention

meet_deb85 · Post by **meet_deb85** » Tue Oct 18, 2011 3:38 am

I don't think there is any way of doing it using 1 lookup stage

manoj_23sakthi · Post by **manoj_23sakthi** » Tue Oct 18, 2011 4:43 am

i am not sure abt this...
in constrain we can do this...

ray.wurlod · Post by **ray.wurlod** » Tue Oct 18, 2011 3:47 pm

Lookup stages don't have constraints.

manoj_23sakthi · Post by **manoj_23sakthi** » Wed Oct 19, 2011 1:59 am

hi ray,

In look up property we can give condition

ray.wurlod · Post by **ray.wurlod** » Wed Oct 19, 2011 4:08 pm

You can give a condition about whether or not to attempt the lookup, but you can not make the lookup itself conditional which is what your original post suggests. Perform the lookup with a Lookup stage unconditionally, and handle the condition elsewhere - maybe only load the records into the reference data set that meet the condition, maybe test the condition downstream of the Lookup stage in a Filter, Switch or Transformer stage.