DSXchange

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?

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.
As per my understanding,your condition is not possible using range lookup.