Talend community forum / Lookup with between clause

alfredo123 · 2012-07-12 18:29:18

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 · 2012-07-13 01:57:49

Have a look at How to get tMap to join Between values?.

alfredo123 · 2012-07-13 22:04:41

Thanks this worked! Appreciate your help.

Announcement

Unanswered posts

#1 2012-07-12 18:29:18

Lookup with between clause

#2 2012-07-13 01:57:49

Re: Lookup with between clause

#3 2012-07-13 22:04:41

Re: Lookup with between clause

Board footer