topic Re: Two Tables Join in QlikView https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72883#M606207 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>TAB1:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; autonumber(Rows&amp;field1&amp;field2) as key,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rows,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field3</P><P></P><P>FROM TAB1;</P><P></P><P>OUTER JOIN</P><P></P><P>TAB2:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; autonumber(Rows&amp;field1&amp;field2) as key,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field4</P><P>FROM TAB2;</P></BODY></HTML> Thu, 08 Mar 2018 10:13:44 GMT YoussefBelloum 2018-03-08T10:13:44Z Two Tables Join https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72882#M606206 <HTML><HEAD></HEAD><BODY><P>Hi, how can I merge these two tables and obtain output in jpg attachment?</P><P>Thank You very much!!!!!</P></BODY></HTML> Thu, 08 Mar 2018 10:07:38 GMT https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72882#M606206 Anonymous 2018-03-08T10:07:38Z Re: Two Tables Join https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72883#M606207 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>TAB1:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; autonumber(Rows&amp;field1&amp;field2) as key,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rows,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field3</P><P></P><P>FROM TAB1;</P><P></P><P>OUTER JOIN</P><P></P><P>TAB2:</P><P>LOAD</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; autonumber(Rows&amp;field1&amp;field2) as key,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; field4</P><P>FROM TAB2;</P></BODY></HTML> Thu, 08 Mar 2018 10:13:44 GMT https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72883#M606207 YoussefBelloum 2018-03-08T10:13:44Z Re: Two Tables Join https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72884#M606208 <HTML><HEAD></HEAD><BODY><P>load * </P><P>from Tab1;</P><P>join </P><P>load Rows,Field4</P><P>from Tab2</P></BODY></HTML> Thu, 08 Mar 2018 10:14:02 GMT https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72884#M606208 lironbaram 2018-03-08T10:14:02Z Re: Two Tables Join https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72885#M606209 <HTML><HEAD></HEAD><BODY><P>Please check</P></BODY></HTML> Thu, 08 Mar 2018 10:16:41 GMT https://community.qlik.com/t5/QlikView/Two-Tables-Join/m-p/72885#M606209 prma7799 2018-03-08T10:16:41Z