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?
How to implement Range Lookup
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
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.
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
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/