https://community.qlik.com/t5/Connectivity-Data-Prep/joins/m-p/1797859#M8761 <P>Hi,</P><P>I have to left-join 2 tables, with a complicated connection (the date column in table1 must be between 2 date columns in table 2, and the ID column have to be equal in both tables).</P><P>How can I do that? (I have not any experience in Qlik-Sense).</P><P>Thanks,</P><P>Natan&nbsp;</P> Thu, 23 Dec 2021 14:23:49 GMT natanzil 2021-12-23T14:23:49Z https://community.qlik.com/t5/Connectivity-Data-Prep/joins/m-p/1797859#M8761 <P>Hi,</P><P>I have to left-join 2 tables, with a complicated connection (the date column in table1 must be between 2 date columns in table 2, and the ID column have to be equal in both tables).</P><P>How can I do that? (I have not any experience in Qlik-Sense).</P><P>Thanks,</P><P>Natan&nbsp;</P> Thu, 23 Dec 2021 14:23:49 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/joins/m-p/1797859#M8761 natanzil 2021-12-23T14:23:49Z