Condition in Lookup Stage

mspanda · Post by **mspanda** » Tue Jul 10, 2007 12:37 am

Hi,

I have an issue in the lookup stage. In Lookup table I have column1 and in reference table I have column2,column3 and column4. I need to specify a condition in lookupstage that column1 lies in between Column2 and column3 then retrieve column4 from reference table into the target.

How do I specify that kind of criteria in Lookup Stage?

Regards
Prasanna

ArndW · Post by **ArndW** » Tue Jul 10, 2007 1:08 am

That type of a range lookup will only work on Database objects. You need to use a sparse lookup and user-defined SQL in order to specify your BETWEEN condition.

devidotcom · Post by **devidotcom** » Tue Jul 10, 2007 2:52 am

Hi Prasanna,

If the amount of data in the input link is more when compared to reference table than this would be a good option to use a sparse lookup.
That is 1:10000 ratio between reference link:input link

Else you would have to use a transformer stage or a filter stage after lookup stage to check column1 lies in between Column2 and column3 and then fetch the column 4.

Thanks
Devi

ray.wurlod · Post by **ray.wurlod** » Tue Jul 10, 2007 5:42 am

Upgrade to version 8.0. Then you get range lookups.