How to implement Range Lookup

[vamsi.4a6]

I have two fields in source cola,colb and two fields in reference colc,cold.
I need to implement the below logic in Range Lookup.


lkp.colc = src.cola
lkp.cold > src.colb

As of now I am implementing lkp.colc = src.cola using Join stage and then implementing lkp.cold > src.colb using filter stage.New to 8.5 Just want to know how to implement Using Range Lookup?

[prasson_ibm]

Hi,
Your lookup condition is between two different lookup columns.In lookup stage range can be calculated between two source columns(Range columns) and one lookup columns for e.g.

Code: Select all

src.cola < lkp.colc < src.colb 

As per my understanding,your condition is not possible using range lookup.