topic Re: Join 2 Tables in App Development https://community.qlik.com/t5/App-Development/Join-2-Tables/m-p/2515704#M105694 <P>just do outer join. like</P><P>&nbsp;</P><P><STRONG>R_TAB</STRONG><SPAN>:</SPAN><BR /><SPAN>LOAD * INLINE [</SPAN><BR /><SPAN>OFC, R_NAME, R_UID, INITIALS, DEPT</SPAN><BR /><SPAN>"Adams Office", John Scott, 1001, JSC, HR</SPAN><BR /><SPAN>"Adams Office", Stephen Avey, 2007, SAV, FIN</SPAN><BR /><SPAN>"Adams Office", John Scott, 2200, JSC, HR</SPAN><BR /><SPAN>"Adams Office", Stephen Avey, 1009, SAV, FIN</SPAN><BR /><SPAN>"Bob Office", Jonathan Arzani, 2001, JAR, HR</SPAN><BR /><SPAN>"Bob Office", Lucy Parker, 4001, LPA, SALES</SPAN><BR /><SPAN>"Bob Office", Jonathan Arzani, 2003, JAR, HR</SPAN><BR /><SPAN>"Andersen Office", Brad Smith, 2010, BSM, SALES</SPAN><BR /><SPAN>"Andersen Office", Nader Yeager, 4009, NYE, FIN</SPAN><BR /><SPAN>"Harrison Office", Eric Reece, 5001, ERE, HR</SPAN><BR /><SPAN>"Harrison Office", Kim White, 5003, KWH, FIN</SPAN><BR /><SPAN>];</SPAN></P><P><SPAN>join</SPAN></P><P><SPAN>LOAD&nbsp;OfficeName as OFC,&nbsp;Employee_Name as&nbsp;R_NAME INLINE [<BR />OfficeName, Employee_Name<BR />"Adams Office", John Scott<BR />"Adams Office", Stephen Avey<BR />"Andersen Office", Brad Smith<BR />"Andersen Office", Nader Yeager<BR />"Bob Office", Jonathan Arzani<BR />"Bob Office", Lucy Parker<BR />"Bob Office", Jade Smith<BR />"Bob Office", Daniel Wade<BR />"Grant Office", Grant Saka<BR />"Grant Office", Mike Arnold<BR />"Grant Office", Chris Paul<BR />];</SPAN></P><DIV><!-- Versioning Control Panel if versioning = true ! --><!-- Launcher --><!-- Toolbar --><!-- Site Menu --><!-- Generic Aria Live message container --><DIV class="">&nbsp;</DIV></DIV><DIV><!-- Symbol definitions --></DIV><!-- end #ae_app --> Fri, 25 Apr 2025 04:31:48 GMT PrashantSangle 2025-04-25T04:31:48Z Join 2 Tables https://community.qlik.com/t5/App-Development/Join-2-Tables/m-p/2515691#M105693 <P>I have following table 2 tables named <STRONG>Self_Review</STRONG> and <STRONG>R_tab:</STRONG></P><P><STRONG>Self_Review:</STRONG><BR />LOAD * INLINE [<BR />OfficeName, Employee_Name<BR />"Adams Office", John Scott<BR />"Adams Office", Stephen Avey<BR />"Andersen Office", Brad Smith<BR />"Andersen Office", Nader Yeager<BR />"Bob Office", Jonathan Arzani<BR />"Bob Office", Lucy Parker<BR />"Bob Office", Jade Smith<BR />"Bob Office", Daniel Wade<BR />"Grant Office", Grant Saka<BR />"Grant Office", Mike Arnold<BR />"Grant Office", Chris Paul<BR />];</P><P><STRONG>R_TAB</STRONG>:<BR />LOAD * INLINE [<BR />OFC, R_NAME, R_UID, INITIALS, DEPT<BR />"Adams Office", John Scott, 1001, JSC, HR<BR />"Adams Office", Stephen Avey, 2007, SAV, FIN<BR />"Adams Office", John Scott, 2200, JSC, HR<BR />"Adams Office", Stephen Avey, 1009, SAV, FIN<BR />"Bob Office", Jonathan Arzani, 2001, JAR, HR<BR />"Bob Office", Lucy Parker, 4001, LPA, SALES<BR />"Bob Office", Jonathan Arzani, 2003, JAR, HR<BR />"Andersen Office", Brad Smith, 2010, BSM, SALES<BR />"Andersen Office", Nader Yeager, 4009, NYE, FIN<BR />"Harrison Office", Eric Reece, 5001, ERE, HR<BR />"Harrison Office", Kim White, 5003, KWH, FIN<BR />];<BR />I need to create a final table with which needs to named still as&nbsp;<STRONG>R_TAB&nbsp; </STRONG>as shown in attached screenshot.</P><!-- end #ae_app --> Fri, 25 Apr 2025 03:50:12 GMT https://community.qlik.com/t5/App-Development/Join-2-Tables/m-p/2515691#M105693 MH376 2025-04-25T03:50:12Z Re: Join 2 Tables https://community.qlik.com/t5/App-Development/Join-2-Tables/m-p/2515704#M105694 <P>just do outer join. like</P><P>&nbsp;</P><P><STRONG>R_TAB</STRONG><SPAN>:</SPAN><BR /><SPAN>LOAD * INLINE [</SPAN><BR /><SPAN>OFC, R_NAME, R_UID, INITIALS, DEPT</SPAN><BR /><SPAN>"Adams Office", John Scott, 1001, JSC, HR</SPAN><BR /><SPAN>"Adams Office", Stephen Avey, 2007, SAV, FIN</SPAN><BR /><SPAN>"Adams Office", John Scott, 2200, JSC, HR</SPAN><BR /><SPAN>"Adams Office", Stephen Avey, 1009, SAV, FIN</SPAN><BR /><SPAN>"Bob Office", Jonathan Arzani, 2001, JAR, HR</SPAN><BR /><SPAN>"Bob Office", Lucy Parker, 4001, LPA, SALES</SPAN><BR /><SPAN>"Bob Office", Jonathan Arzani, 2003, JAR, HR</SPAN><BR /><SPAN>"Andersen Office", Brad Smith, 2010, BSM, SALES</SPAN><BR /><SPAN>"Andersen Office", Nader Yeager, 4009, NYE, FIN</SPAN><BR /><SPAN>"Harrison Office", Eric Reece, 5001, ERE, HR</SPAN><BR /><SPAN>"Harrison Office", Kim White, 5003, KWH, FIN</SPAN><BR /><SPAN>];</SPAN></P><P><SPAN>join</SPAN></P><P><SPAN>LOAD&nbsp;OfficeName as OFC,&nbsp;Employee_Name as&nbsp;R_NAME INLINE [<BR />OfficeName, Employee_Name<BR />"Adams Office", John Scott<BR />"Adams Office", Stephen Avey<BR />"Andersen Office", Brad Smith<BR />"Andersen Office", Nader Yeager<BR />"Bob Office", Jonathan Arzani<BR />"Bob Office", Lucy Parker<BR />"Bob Office", Jade Smith<BR />"Bob Office", Daniel Wade<BR />"Grant Office", Grant Saka<BR />"Grant Office", Mike Arnold<BR />"Grant Office", Chris Paul<BR />];</SPAN></P><DIV><!-- Versioning Control Panel if versioning = true ! --><!-- Launcher --><!-- Toolbar --><!-- Site Menu --><!-- Generic Aria Live message container --><DIV class="">&nbsp;</DIV></DIV><DIV><!-- Symbol definitions --></DIV><!-- end #ae_app --> Fri, 25 Apr 2025 04:31:48 GMT https://community.qlik.com/t5/App-Development/Join-2-Tables/m-p/2515704#M105694 PrashantSangle 2025-04-25T04:31:48Z