topic Re: join 2 tables based on same id in QlikView https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322101#M1191847 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>load fields from tables like this:</P><P>LOAD</P><P>"Table1_id" as [ID]</P><P>....</P><P>LOAD </P><P>"Table2_id" as [ID]</P><P>...</P><P></P><P>just give the fields you want to join the same name.</P><P></P><P>Regards</P></BODY></HTML> Mon, 27 Jun 2011 06:02:24 GMT 2011-06-27T06:02:24Z join 2 tables based on same id https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322099#M1191845 <HTML><HEAD></HEAD><BODY><P>hI,</P><P></P><P>I am having 2 tables wit same id.how to join that 2 tables based on id. shall i use join or mapping function...</P></BODY></HTML> Mon, 27 Jun 2011 05:43:59 GMT https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322099#M1191845 2011-06-27T05:43:59Z join 2 tables based on same id https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322100#M1191846 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp; No need to use join or mapping.</P><P></P><P>&nbsp;&nbsp; Load both the table. Qlikview will automatically join based in similar names in both the tables.</P><P></P><P>&nbsp;&nbsp; By default qlikview uses outter join.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 27 Jun 2011 05:52:59 GMT https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322100#M1191846 kaushiknsolanki 2011-06-27T05:52:59Z Re: join 2 tables based on same id https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322101#M1191847 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>load fields from tables like this:</P><P>LOAD</P><P>"Table1_id" as [ID]</P><P>....</P><P>LOAD </P><P>"Table2_id" as [ID]</P><P>...</P><P></P><P>just give the fields you want to join the same name.</P><P></P><P>Regards</P></BODY></HTML> Mon, 27 Jun 2011 06:02:24 GMT https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322101#M1191847 2011-06-27T06:02:24Z join 2 tables based on same id https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322102#M1191848 <HTML><HEAD></HEAD><BODY><P> YEAH ITS WORKING...</P></BODY></HTML> Mon, 27 Jun 2011 06:09:16 GMT https://community.qlik.com/t5/QlikView/join-2-tables-based-on-same-id/m-p/322102#M1191848 2011-06-27T06:09:16Z