topic interval match in QlikView https://community.qlik.com/t5/QlikView/interval-match/m-p/1110187#M367226 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I was working on intervalmatch on sales. min_sales and max_sales. Now, there's a synthetic key. How can i solve it?</P><P><IMG alt="synthetic_key.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135913_synthetic_key.jpg" style="height: auto;" /></P><P></P><P>Rgds, </P><P></P><P>Jim</P></BODY></HTML> Tue, 30 Aug 2016 03:30:24 GMT jim_chan 2016-08-30T03:30:24Z interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110187#M367226 <HTML><HEAD></HEAD><BODY><P>Hi guys, </P><P></P><P>I was working on intervalmatch on sales. min_sales and max_sales. Now, there's a synthetic key. How can i solve it?</P><P><IMG alt="synthetic_key.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135913_synthetic_key.jpg" style="height: auto;" /></P><P></P><P>Rgds, </P><P></P><P>Jim</P></BODY></HTML> Tue, 30 Aug 2016 03:30:24 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110187#M367226 jim_chan 2016-08-30T03:30:24Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110188#M367227 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/message/1057590">Resolve Synthetic key in interval match</A></P></BODY></HTML> Tue, 30 Aug 2016 03:46:33 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110188#M367227 varshavig12 2016-08-30T03:46:33Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110189#M367228 <HTML><HEAD></HEAD><BODY><P>Why not noconcatenate between two directories</P></BODY></HTML> Tue, 30 Aug 2016 03:51:18 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110189#M367228 Anil_Babu_Samineni 2016-08-30T03:51:18Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110190#M367229 <HTML><HEAD></HEAD><BODY><P>Did you check this?</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3037">IntervalMatch</A></P></BODY></HTML> Tue, 30 Aug 2016 05:02:01 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110190#M367229 Anonymous 2016-08-30T05:02:01Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110191#M367230 <HTML><HEAD></HEAD><BODY><P>yeah , i did follow. and thats y i got a synthetic key table. i am just wondering, how can i get rid of it.</P><P></P><P>some told me use left join, some told me to create a key. </P><P></P><P>Rgds</P><P></P><P>Jim</P></BODY></HTML> Tue, 30 Aug 2016 05:12:14 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110191#M367230 jim_chan 2016-08-30T05:12:14Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110192#M367231 <HTML><HEAD></HEAD><BODY><P>Yes, Join is preferred while working with synthetic keys in interval match.</P><P></P><P>Check this as well?</P><P></P><P><A href="https://community.qlik.com/thread/39798">Removing synthetic keys when using Interval Match</A></P></BODY></HTML> Tue, 30 Aug 2016 05:17:30 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110192#M367231 Anonymous 2016-08-30T05:17:30Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110193#M367232 <HTML><HEAD></HEAD><BODY><P>read, it actually says need not to remove the synthetic key.&nbsp; what do you think?</P></BODY></HTML> Tue, 30 Aug 2016 05:31:22 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110193#M367232 jim_chan 2016-08-30T05:31:22Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110194#M367233 <HTML><HEAD></HEAD><BODY><P>in this case left join is preferable. i also used that</P></BODY></HTML> Tue, 30 Aug 2016 05:40:14 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110194#M367233 arulsettu 2016-08-30T05:40:14Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110195#M367234 <HTML><HEAD></HEAD><BODY><P>It says--- <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"> a left join will add columns to the fact table - which will increase the memory usage. A solution without a left join could probably use less memory.</SPAN></P></BODY></HTML> Tue, 30 Aug 2016 05:43:52 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110195#M367234 jim_chan 2016-08-30T05:43:52Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110196#M367235 <HTML><HEAD></HEAD><BODY><P>have you tried nocancatenate ?</P></BODY></HTML> Tue, 30 Aug 2016 06:01:45 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110196#M367235 arulsettu 2016-08-30T06:01:45Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110197#M367236 <HTML><HEAD></HEAD><BODY><P>nope.</P></BODY></HTML> Tue, 30 Aug 2016 06:02:27 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110197#M367236 jim_chan 2016-08-30T06:02:27Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110198#M367237 <HTML><HEAD></HEAD><BODY><P>If you get the accurate numbers from the data model, there is no need to remove the synthetic key. If you are not sure you get the accurate numbers, then it is safer to remove the synthetic key. Synthetic key as such is not a problem, but depending on the data relations it can cause unexpected results. </P></BODY></HTML> Tue, 30 Aug 2016 06:13:14 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110198#M367237 ToniKautto 2016-08-30T06:13:14Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110199#M367238 <HTML><HEAD></HEAD><BODY><P>i thought so&nbsp; too. but thanks All.!!!</P></BODY></HTML> Tue, 30 Aug 2016 06:21:17 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110199#M367238 jim_chan 2016-08-30T06:21:17Z Re: interval match https://community.qlik.com/t5/QlikView/interval-match/m-p/1110200#M367239 <HTML><HEAD></HEAD><BODY><P>Use Left join.. If you concern about memory usage then use optimisation techniques.&nbsp;&nbsp; </P></BODY></HTML> Tue, 30 Aug 2016 07:01:55 GMT https://community.qlik.com/t5/QlikView/interval-match/m-p/1110200#M367239 2016-08-30T07:01:55Z