Condition in Lookup stage

mspanda · Post by **mspanda** » Mon Jul 23, 2007 12:46 am

Hi,

I need a solution for one of my requirement, which is as follows:

1. I have a Look up table In which I have column named as "Profit Center".

2. I have a reference table in which I have two columns "Valfrom" and "Valto"
3. I need to specify a condition in Lookup stage as
"profit Center">="valfrom" and "profit Center"<="valto".

Please suggest me how do I do this?

Regards
Prasanna lakshmi

Maveric · Post by **Maveric** » Mon Jul 23, 2007 1:05 am

Dont think you can get reference link columns in the constraints in the lookup. You will have to use a filter stage after the lookup.

ray.wurlod · Post by **ray.wurlod** » Mon Jul 23, 2007 1:15 am

If you are using DB2 or Oracle Enterprise stage to feed to reference input link then you could use this SQL.

Otherwise use a Join stage, or upgrade to version 8 in which the ability to perform range lookups is in the Lookup stage. Vincent has created a recent blog on the latter.

mspanda · Post by **mspanda** » Mon Jul 23, 2007 11:44 pm

Is there any other way to achieve tat reference link column in Constraint.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 24, 2007 4:13 am

Of course.

You could write your own stage (a Build stage).
You could write a parallel routine, and invoke it from a Transformer stage.

Just to name two.