https://community.qlik.com/t5/Talend-Studio/Lookup-with-between-clause/m-p/2232156#M22220 Thanks this worked! Appreciate your help. Fri, 13 Jul 2012 21:04:41 GMT Anonymous 2012-07-13T21:04:41Z https://community.qlik.com/t5/Talend-Studio/Lookup-with-between-clause/m-p/2232154#M22218 Below is the scenario<BR />Input table has a date column say input_date_col<BR />Lookup table has columns start_date and end_date and lookup_key column<BR />I need to return lookup_key column when input_date_col is between start_date and end_date.<BR />I tried putting this information in the lookup but it gives me an error. Is there a way to do this? Thu, 12 Jul 2012 17:29:18 GMT https://community.qlik.com/t5/Talend-Studio/Lookup-with-between-clause/m-p/2232154#M22218 Anonymous 2012-07-12T17:29:18Z https://community.qlik.com/t5/Talend-Studio/Lookup-with-between-clause/m-p/2232155#M22219 Have a look at <A href="https://community.qlik.com/s/feed/0D53p00007vCsvUCAS" target="_blank" rel="nofollow noopener noreferrer">https://community.talend.com/t5/Design-and-Development/How-to-get-tMap-to-join-Between-values/td-p/60523</A>. Fri, 13 Jul 2012 00:57:49 GMT https://community.qlik.com/t5/Talend-Studio/Lookup-with-between-clause/m-p/2232155#M22219 alevy 2012-07-13T00:57:49Z https://community.qlik.com/t5/Talend-Studio/Lookup-with-between-clause/m-p/2232156#M22220 Thanks this worked! Appreciate your help. Fri, 13 Jul 2012 21:04:41 GMT https://community.qlik.com/t5/Talend-Studio/Lookup-with-between-clause/m-p/2232156#M22220 Anonymous 2012-07-13T21:04:41Z