range lookup
Posted: Thu Feb 10, 2011 2:04 pm
The topic is not new but still not clear how to use this one.
My main stream has one field key and a date , let say Eff_dt.
The reference has a field key and 2 dates Start_dt and End_dt.
No duplicates , no multiple records.... a clean lookup.
Actually when I edit the lookup range, the headers are indicating exactly the opposite within the values.
The "Range Column" shows me the main stream's fields and the "Input Column" shows me the reference's fields.
What am I doing wrong ? Or what is the way to configure this stage properly ?
I want to have the main.Eff_dt between ref.Start_dt and ref.End_dt.
My main stream has one field key and a date , let say Eff_dt.
The reference has a field key and 2 dates Start_dt and End_dt.
No duplicates , no multiple records.... a clean lookup.
Actually when I edit the lookup range, the headers are indicating exactly the opposite within the values.
The "Range Column" shows me the main stream's fields and the "Input Column" shows me the reference's fields.
What am I doing wrong ? Or what is the way to configure this stage properly ?
I want to have the main.Eff_dt between ref.Start_dt and ref.End_dt.