topic Re: Resident load table not loading in QlikView https://community.qlik.com/t5/QlikView/Resident-load-table-not-loading/m-p/1055461#M943995 <HTML><HEAD></HEAD><BODY><P>you hav 2 tables that are exactly the same so QlikView will automatically concetnate them together - when you look at the table you ahve, it will ahve twice the amount of entries it should have</P><P></P><P>what is the purpsoe of doing the resident load after the intial load?</P></BODY></HTML> Fri, 08 Jan 2016 18:07:40 GMT 2016-01-08T18:07:40Z Resident load table not loading https://community.qlik.com/t5/QlikView/Resident-load-table-not-loading/m-p/1055459#M943993 <HTML><HEAD></HEAD><BODY><P>Hello, I'm having trouble with Resident load</P><P></P><P>Syntax</P><P></P><P>SQL_table:</P><P>SQL</P><P>select distint *</P><P>from table;</P><P>Store SQL_Table into xxxxx;</P><P></P><P>Final:</P><P>LOAD *</P><P></P><P>Resident SQL_table;</P><P>drop table SQL_table;</P><P></P><P></P><P>Table Final does not exitst, why?</P></BODY></HTML> Fri, 08 Jan 2016 18:03:50 GMT https://community.qlik.com/t5/QlikView/Resident-load-table-not-loading/m-p/1055459#M943993 Anonymous 2016-01-08T18:03:50Z Re: Resident load table not loading https://community.qlik.com/t5/QlikView/Resident-load-table-not-loading/m-p/1055460#M943994 <HTML><HEAD></HEAD><BODY><P>the table gets auto-concatenated, try</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Final:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>NOCONCATENATE</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">LOAD *</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Resident SQL_table;</P></BODY></HTML> Fri, 08 Jan 2016 18:05:22 GMT https://community.qlik.com/t5/QlikView/Resident-load-table-not-loading/m-p/1055460#M943994 swuehl 2016-01-08T18:05:22Z Re: Resident load table not loading https://community.qlik.com/t5/QlikView/Resident-load-table-not-loading/m-p/1055461#M943995 <HTML><HEAD></HEAD><BODY><P>you hav 2 tables that are exactly the same so QlikView will automatically concetnate them together - when you look at the table you ahve, it will ahve twice the amount of entries it should have</P><P></P><P>what is the purpsoe of doing the resident load after the intial load?</P></BODY></HTML> Fri, 08 Jan 2016 18:07:40 GMT https://community.qlik.com/t5/QlikView/Resident-load-table-not-loading/m-p/1055461#M943995 2016-01-08T18:07:40Z