Lookup with between clause

[Anonymous]

Below is the scenario
Input table has a date column say input_date_col
Lookup table has columns start_date and end_date and lookup_key column
I need to return lookup_key column when input_date_col is between start_date and end_date.
I tried putting this information in the lookup but it gives me an error. Is there a way to do this?

[alevy]

Have a look at https://community.talend.com/t5/Design-and-Development/How-to-get-tMap-to-join-Between-values/td-p/6....

[Anonymous]

Thanks this worked! Appreciate your help.