topic Re: major drawbacks of Joins in QlikView https://community.qlik.com/t5/QlikView/major-drawbacks-of-Joins/m-p/621339#M1112375 <HTML><HEAD></HEAD><BODY><P>PFA white paper that explains joins and applymap in detail.</P><P></P><P>-Sundar</P></BODY></HTML> Sun, 23 Feb 2014 10:58:25 GMT sundarakumar 2014-02-23T10:58:25Z major drawbacks of Joins https://community.qlik.com/t5/QlikView/major-drawbacks-of-Joins/m-p/621337#M1112373 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 14pt; color: #3366ff;">Hi</SPAN></P><P></P><P><SPAN style="font-size: 14pt; color: #3366ff;">this is venu, New to QV</SPAN></P><P></P><P><SPAN style="font-size: 14pt; color: #3366ff;">Applymap is better than joins in One&nbsp; to One relation...</SPAN></P><P></P><P></P><P><SPAN style="font-size: 14pt; color: #3366ff;">for why?</SPAN></P><P></P><P></P><P><SPAN style="font-size: 14pt; color: #3366ff;">wHAT ARE THE MAJOR DRAWBACKS OF JOINS?</SPAN></P><P></P><P><SPAN style="font-size: 14pt; color: #3366ff;">THANKS IN advance</SPAN></P><P></P><P><SPAN style="font-size: 14pt; color: #3366ff;">VEnu</SPAN></P></BODY></HTML> Sun, 23 Feb 2014 10:33:45 GMT https://community.qlik.com/t5/QlikView/major-drawbacks-of-Joins/m-p/621337#M1112373 2014-02-23T10:33:45Z Re: major drawbacks of Joins https://community.qlik.com/t5/QlikView/major-drawbacks-of-Joins/m-p/621338#M1112374 <HTML><HEAD></HEAD><BODY><P>Joins will result in bigger table, increasing the size...</P><P>applymap will just fetch values from one table to another, applymap will work like lookup just adding one column to what is already existing but join will join both the tables so the number of lines will increase(not actually what was there in the first table alone)</P><P></P><P>-Sundar</P></BODY></HTML> Sun, 23 Feb 2014 10:55:37 GMT https://community.qlik.com/t5/QlikView/major-drawbacks-of-Joins/m-p/621338#M1112374 sundarakumar 2014-02-23T10:55:37Z Re: major drawbacks of Joins https://community.qlik.com/t5/QlikView/major-drawbacks-of-Joins/m-p/621339#M1112375 <HTML><HEAD></HEAD><BODY><P>PFA white paper that explains joins and applymap in detail.</P><P></P><P>-Sundar</P></BODY></HTML> Sun, 23 Feb 2014 10:58:25 GMT https://community.qlik.com/t5/QlikView/major-drawbacks-of-Joins/m-p/621339#M1112375 sundarakumar 2014-02-23T10:58:25Z