topic Re: How to perform left join? in QlikView https://community.qlik.com/t5/QlikView/How-to-perform-left-join/m-p/365861#M1172484 <HTML><HEAD></HEAD><BODY><P>Dear Can you attach the sample ???</P></BODY></HTML> Mon, 25 Jun 2012 06:02:44 GMT gaurav2017 2012-06-25T06:02:44Z How to perform left join? https://community.qlik.com/t5/QlikView/How-to-perform-left-join/m-p/365860#M1172482 <HTML><HEAD></HEAD><BODY><P>Hello There,</P><P></P><P>How to make left join in QLikview if I have one qvd file and one excel file?</P><P></P><P>Best,</P><P>Siva</P></BODY></HTML> Mon, 25 Jun 2012 05:18:55 GMT https://community.qlik.com/t5/QlikView/How-to-perform-left-join/m-p/365860#M1172482 siva_boggarapu 2012-06-25T05:18:55Z Re: How to perform left join? https://community.qlik.com/t5/QlikView/How-to-perform-left-join/m-p/365861#M1172484 <HTML><HEAD></HEAD><BODY><P>Dear Can you attach the sample ???</P></BODY></HTML> Mon, 25 Jun 2012 06:02:44 GMT https://community.qlik.com/t5/QlikView/How-to-perform-left-join/m-p/365861#M1172484 gaurav2017 2012-06-25T06:02:44Z Re: How to perform left join? https://community.qlik.com/t5/QlikView/How-to-perform-left-join/m-p/365862#M1172485 <HTML><HEAD></HEAD><BODY><P>Hi Siva,</P><P></P><P>Try like this</P><P></P><P>QVDTableName:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; *</P><P>FROM QVDFileName;</P><P></P><P>LEFT JOIN (QVDTableName)</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp; *</P><P>FROM ExcelFileName;</P><P></P><P>Note: The column which you want to join should have the same name on both the tables.</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 25 Jun 2012 06:45:10 GMT https://community.qlik.com/t5/QlikView/How-to-perform-left-join/m-p/365862#M1172485 jagan 2012-06-25T06:45:10Z