topic Re: Joining Tables Using IntervalMatch in QlikView https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/118#M25 <HTML><HEAD></HEAD><BODY><P>Thank you for your response. But, I'm expecting Table1 should look like this at the end,</P><P></P><P>Table1:</P><P>CLNDR_DT, CURRENCY, Temp_ID, USDRATE, EUR_USDRATE</P><P>10/2/2017, EUR, 1, 1.1814, 1.1814</P><P>10/3/2017, CAD, 2, 0.79949, 1.1733</P><P>10/4/2017, AUD, 3, 0.7836, 1.1744</P><P>10/4/2017, USD, 4, 1, 1.1744</P><P>];</P></BODY></HTML> Sun, 14 Jan 2018 09:13:36 GMT sreenivaskollur 2018-01-14T09:13:36Z Joining Tables Using IntervalMatch https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/116#M23 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Hi Folks,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Could you please help me to get the solution for this?</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I've two tables in my dataset.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Table1:</SPAN></P><P><SPAN style="font-size: 13.3333px;">CLNDR_DT CURRENCY Temp_ID</SPAN></P><P><SPAN style="font-size: 13.3333px;">10/2/2017 EUR 1</SPAN></P><P><SPAN style="font-size: 13.3333px;">10/3/2017 CAD 2</SPAN></P><P><SPAN style="font-size: 13.3333px;">10/4/2017 AUD 3</SPAN></P><P><SPAN style="font-size: 13.3333px;">10/4/2017 USD 4</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Table2:</SPAN></P><P><SPAN style="font-size: 13.3333px;">CURRENCY USDRATE STARTDATE ENDDATE</SPAN></P><P><SPAN style="font-size: 13.3333px;">EUR 1.1814 10/2/2017 10/2/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">EUR 1.1733 10/3/2017 10/3/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">EUR 1.1744 10/4/2017 10/4/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">CAD 0.8018 10/2/2017 10/2/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">CAD 0.79949 10/3/2017 10/3/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">CAD 0.80083 10/4/2017 10/4/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">AUD 0.7834 10/2/2017 10/2/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">AUD 0.7827 10/3/2017 10/3/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">AUD 0.7836 10/4/2017 10/4/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">USD 1 10/2/2017 10/2/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">USD 1 10/3/2017 10/3/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;">USD 1 10/4/2017 10/4/2017</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Now, I would like to have two additional fields in Table1.</SPAN></P><P><SPAN style="font-size: 13.3333px;">1. USDRATE</SPAN></P><P><SPAN style="font-size: 13.3333px;"> --Value for this field should be from Table2.USDRATE field where Table1.CURRENCY=Table2.CURRENCY and Table1.CLNDR_DT matches the intervals </SPAN>Table2.STARTDATE, Table2.ENDDATE.</P><P><SPAN style="font-size: 13.3333px;">2. EUR_USDRATE</SPAN></P><P><SPAN style="font-size: 13.3333px;"> --Value for this field should be from Table2.USDRATE field where Table2.CURRENCY = 'EUR' and Table1.CLNDR_DT matches the intervals </SPAN>Table2.STARTDATE, Table2.ENDDATE.</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I've read some community links on IntervalMatch to achieve this, but can't figure out the exact code for getting this done. Please help me. </SPAN>Your help is very much appreciated. Thank you.</P></BODY></HTML> Sun, 14 Jan 2018 00:09:39 GMT https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/116#M23 sreenivaskollur 2018-01-14T00:09:39Z Re: Joining Tables Using IntervalMatch https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/117#M24 <HTML><HEAD></HEAD><BODY><P>PFA </P></BODY></HTML> Sun, 14 Jan 2018 03:02:30 GMT https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/117#M24 Anil_Babu_Samineni 2018-01-14T03:02:30Z Re: Joining Tables Using IntervalMatch https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/118#M25 <HTML><HEAD></HEAD><BODY><P>Thank you for your response. But, I'm expecting Table1 should look like this at the end,</P><P></P><P>Table1:</P><P>CLNDR_DT, CURRENCY, Temp_ID, USDRATE, EUR_USDRATE</P><P>10/2/2017, EUR, 1, 1.1814, 1.1814</P><P>10/3/2017, CAD, 2, 0.79949, 1.1733</P><P>10/4/2017, AUD, 3, 0.7836, 1.1744</P><P>10/4/2017, USD, 4, 1, 1.1744</P><P>];</P></BODY></HTML> Sun, 14 Jan 2018 09:13:36 GMT https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/118#M25 sreenivaskollur 2018-01-14T09:13:36Z Re: Joining Tables Using IntervalMatch https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/119#M26 <HTML><HEAD></HEAD><BODY><P>Hi Sreenivas,</P><P></P><P>Hope below is what you want.</P><P></P><P><IMG alt="Joining Tables Using IntervalMatch.PNG" class="jive-image image-1" src="/legacyfs/online/189997_Joining Tables Using IntervalMatch.PNG" style="height: 171px; width: 620px;" /></P><P></P><P>Thanks.</P><P>Aiolos</P></BODY></HTML> Mon, 15 Jan 2018 07:59:45 GMT https://community.qlik.com/t5/QlikView/Joining-Tables-Using-IntervalMatch/m-p/119#M26 uacg0009 2018-01-15T07:59:45Z