topic Join 2 resident tables in QlikView https://community.qlik.com/t5/QlikView/Join-2-resident-tables/m-p/912253#M987326 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I get the following error when I try to exccute this script</P><P></P><P>CT4:</P><P>LOAD * Resident </P><P>[CT];</P><P>left Join (CT4)</P><P>LOAD * Resident </P><P>CT2;</P><P></P><P>Table not found</P><P>left Join (CT4)</P><P>LOAD * Resident </P><P>CT2</P><P></P><P>Both CT and CT2 carry an ID field</P></BODY></HTML> Thu, 23 Jul 2015 13:42:11 GMT tinkerz1 2015-07-23T13:42:11Z Join 2 resident tables https://community.qlik.com/t5/QlikView/Join-2-resident-tables/m-p/912253#M987326 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I get the following error when I try to exccute this script</P><P></P><P>CT4:</P><P>LOAD * Resident </P><P>[CT];</P><P>left Join (CT4)</P><P>LOAD * Resident </P><P>CT2;</P><P></P><P>Table not found</P><P>left Join (CT4)</P><P>LOAD * Resident </P><P>CT2</P><P></P><P>Both CT and CT2 carry an ID field</P></BODY></HTML> Thu, 23 Jul 2015 13:42:11 GMT https://community.qlik.com/t5/QlikView/Join-2-resident-tables/m-p/912253#M987326 tinkerz1 2015-07-23T13:42:11Z Re: Join 2 resident tables https://community.qlik.com/t5/QlikView/Join-2-resident-tables/m-p/912254#M987327 <HTML><HEAD></HEAD><BODY><P>Try with</P><P></P><P>CT4:</P><P>NOCONCATENATE</P><P>LOAD * Resident </P><P>[CT];</P><P>left Join (CT4)</P><P>LOAD * Resident </P><P>CT2;</P><P></P><P>Because The table CT4 is automatically concatenated to CT</P></BODY></HTML> Thu, 23 Jul 2015 13:51:17 GMT https://community.qlik.com/t5/QlikView/Join-2-resident-tables/m-p/912254#M987327 alexandros17 2015-07-23T13:51:17Z