topic Re: Joining tables in QlikView https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1558098#M599222 <P>I found INTERVALMATCH prefix - and maybe this prefix can be used... But i'm new to qlikview and don't know how to exactly use it in above example...&nbsp;</P> Mon, 18 Mar 2019 19:23:06 GMT chrisk44 2019-03-18T19:23:06Z Joining tables https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1557578#M599221 <P>Hello, i got problem with joining tables depend on period.</P><P>TAB1:</P><TABLE><TBODY><TR><TD>DATE_FROM</TD><TD>DATE_TO</TD><TD>KEY</TD><TD>PERIOD_ID</TD><TD>EMPL_NO</TD></TR><TR><TD>02.01.1996</TD><TD>31.12.2006</TD><TD>2385#35066</TD><TD>170645</TD><TD>2385</TD></TR><TR><TD>02.01.1996</TD><TD>31.12.2006</TD><TD>2385#35066</TD><TD>172440</TD><TD>2385</TD></TR><TR><TD>02.01.1996</TD><TD>31.12.2006</TD><TD>2385#35066</TD><TD>178747</TD><TD>2385</TD></TR><TR><TD>16.07.2008</TD><TD>31.01.2010</TD><TD>2385#39645</TD><TD>206095</TD><TD>2385</TD></TR><TR><TD>16.07.2008</TD><TD>31.01.2010</TD><TD>2385#39645</TD><TD>213418</TD><TD>2385</TD></TR><TR><TD>30.11.2018</TD><TD>&nbsp;</TD><TD>2385#43434</TD><TD>260321</TD><TD>2385</TD></TR><TR><TD>30.11.2018</TD><TD>&nbsp;</TD><TD>2385#43434</TD><TD>261284</TD><TD>2385</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>TAB2:</P><TABLE><TBODY><TR><TD>DATE_FROM</TD><TD>DATE_TO</TD><TD>KEY</TD><TD>PERIOD_ID</TD><TD>EMPL_NO</TD></TR><TR><TD>01.01.2007</TD><TD>31.12.2007</TD><TD>2385#ZEWN</TD><TD>178599</TD><TD>2385</TD></TR><TR><TD>01.04.2007</TD><TD>30.04.2007</TD><TD>2385#ZEWN</TD><TD>178299</TD><TD>2385</TD></TR><TR><TD>01.01.2009</TD><TD>31.12.2009</TD><TD>2385#ZEWN</TD><TD>178300</TD><TD>2385</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>DESTINATION_TAB:</P><TABLE><TBODY><TR><TD>DATE_FROM</TD><TD>DATE_TO</TD><TD>KEY</TD><TD>PERIOD_ID</TD><TD>EMPL_NO</TD></TR><TR><TD>02.01.1996</TD><TD>31.12.2006</TD><TD>2385#35066</TD><TD>170645</TD><TD>2385</TD></TR><TR><TD>02.01.1996</TD><TD>31.12.2006</TD><TD>2385#35066</TD><TD>172440</TD><TD>2385</TD></TR><TR><TD>02.01.1996</TD><TD>31.12.2006</TD><TD>2385#35066</TD><TD>178747</TD><TD>2385</TD></TR><TR><TD>16.07.2008</TD><TD>31.01.2010</TD><TD>2385#39645</TD><TD>206095</TD><TD>2385</TD></TR><TR><TD>16.07.2008</TD><TD>31.01.2010</TD><TD>2385#39645</TD><TD>213418</TD><TD>2385</TD></TR><TR><TD>30.11.2018</TD><TD>&nbsp;</TD><TD>2385#43434</TD><TD>260321</TD><TD>2385</TD></TR><TR><TD>30.11.2018</TD><TD>&nbsp;</TD><TD>2385#43434</TD><TD>261284</TD><TD>2385</TD></TR><TR><TD>01.01.2007</TD><TD>31.12.2007</TD><TD>2385#ZEWN</TD><TD>178599</TD><TD>2385</TD></TR><TR><TD>01.04.2007</TD><TD>30.04.2007</TD><TD>2385#ZEWN</TD><TD>178299</TD><TD>2385</TD></TR><TR><TD><FONT color="#FF0000">01.01.2009</FONT></TD><TD><FONT color="#FF0000">31.12.2009</FONT></TD><TD><FONT color="#FF0000">2385#39645</FONT></TD><TD><FONT color="#FF0000">178300</FONT></TD><TD><FONT color="#FF0000">2385</FONT></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>In TAB1 and TAB2 I got series of periods which correspond with KEY and EMPL_NO, tables should be join when period from TAB2 is included in any periods in TAB1, KEY should be taken from TAB1, when period from TAB2 not exist in TAB1 KEY should be taken from TAB2 - how can I get this table join ??</P><P>Regards</P> Sun, 17 Mar 2019 18:44:47 GMT https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1557578#M599221 chrisk44 2019-03-17T18:44:47Z Re: Joining tables https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1558098#M599222 <P>I found INTERVALMATCH prefix - and maybe this prefix can be used... But i'm new to qlikview and don't know how to exactly use it in above example...&nbsp;</P> Mon, 18 Mar 2019 19:23:06 GMT https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1558098#M599222 chrisk44 2019-03-18T19:23:06Z Re: Joining tables https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1567882#M599223 <P>Here are some Design Blog posts that may help you out!</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Using-IntervalMatch/ba-p/1475510" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Using-IntervalMatch/ba-p/1475510</A></P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547</A></P> <P>I know this one can be tricky, the last time I had to use it, took me a bit to get everything sorted out, so hopefully these may help you get your problem solved.</P> <P>Regards,<BR />Brett</P> Wed, 10 Apr 2019 21:40:07 GMT https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1567882#M599223 Brett_Bleess 2019-04-10T21:40:07Z Re: Joining tables https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1570299#M599224 <P>thanks for replay, finally i've got another solution (temporary table with additional Key&nbsp; and compare date with period)</P><P>&nbsp;</P><P>Regards</P> Wed, 17 Apr 2019 07:22:10 GMT https://community.qlik.com/t5/QlikView/Joining-tables/m-p/1570299#M599224 chrisk44 2019-04-17T07:22:10Z