topic Resident load problem in QlikView https://community.qlik.com/t5/QlikView/Resident-load-problem/m-p/185473#M49937 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>See the code below. For some reason the Resident load does not work.. TempTable is created and dropped but Tab2 is not being created.</P><P>Can someone tell me what I'm doing wrong?</P><P>Thanks, Sander</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />TempTable:<BR />LOAD<BR /> Verkooporders.Ordernr AS Ordernr,<BR /> [Verkooporders.Document Type] AS Type<BR /><BR />FROM ..\..\..\Datasources\QVD\Verkooporders\Verkooporders_NL.qvd (qvd)<BR />WHERE [Verkooporders.Document Type] = 'Order';<BR />LEFT JOIN<BR />LOAD<BR /> [Facturen.Ordernr_ factuur] AS Ordernr,<BR /> [Facturen.Ordernr_ factuur] AS Ordernrfactuur,<BR /> Facturen.Factuurnr AS Factuurnr<BR /><BR />FROM ..\..\..\Datasources\QVD\Facturen\Facturen_NL.qvd (qvd)<BR />WHERE ISNULL([Facturen.Ordernr_ factuur]) = 0;<BR />Tab2:<BR />LOAD * RESIDENT TempTable<BR />WHERE ISNULL(Factuurnr)=0;<BR />DROP TABLE TempTable;<BR /></PRE><BR /><BR /></BODY></HTML> Mon, 14 Sep 2009 18:15:48 GMT 2009-09-14T18:15:48Z Resident load problem https://community.qlik.com/t5/QlikView/Resident-load-problem/m-p/185473#M49937 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>See the code below. For some reason the Resident load does not work.. TempTable is created and dropped but Tab2 is not being created.</P><P>Can someone tell me what I'm doing wrong?</P><P>Thanks, Sander</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />TempTable:<BR />LOAD<BR /> Verkooporders.Ordernr AS Ordernr,<BR /> [Verkooporders.Document Type] AS Type<BR /><BR />FROM ..\..\..\Datasources\QVD\Verkooporders\Verkooporders_NL.qvd (qvd)<BR />WHERE [Verkooporders.Document Type] = 'Order';<BR />LEFT JOIN<BR />LOAD<BR /> [Facturen.Ordernr_ factuur] AS Ordernr,<BR /> [Facturen.Ordernr_ factuur] AS Ordernrfactuur,<BR /> Facturen.Factuurnr AS Factuurnr<BR /><BR />FROM ..\..\..\Datasources\QVD\Facturen\Facturen_NL.qvd (qvd)<BR />WHERE ISNULL([Facturen.Ordernr_ factuur]) = 0;<BR />Tab2:<BR />LOAD * RESIDENT TempTable<BR />WHERE ISNULL(Factuurnr)=0;<BR />DROP TABLE TempTable;<BR /></PRE><BR /><BR /></BODY></HTML> Mon, 14 Sep 2009 18:15:48 GMT https://community.qlik.com/t5/QlikView/Resident-load-problem/m-p/185473#M49937 2009-09-14T18:15:48Z AW:Resident load problem https://community.qlik.com/t5/QlikView/Resident-load-problem/m-p/185474#M49938 <HTML><HEAD></HEAD><BODY><P>Try a NOCONCATENATE LOAD * RESIDENT TempTable .</P><P>Rgds,<BR />Joachim</P></BODY></HTML> Mon, 14 Sep 2009 18:22:15 GMT https://community.qlik.com/t5/QlikView/Resident-load-problem/m-p/185474#M49938 biester 2009-09-14T18:22:15Z AW:Resident load problem https://community.qlik.com/t5/QlikView/Resident-load-problem/m-p/185475#M49939 <HTML><HEAD></HEAD><BODY><P>Thanks, Joachim!</P><P>That did the trick..</P><P>Regards, Sander</P></BODY></HTML> Tue, 15 Sep 2009 14:44:37 GMT https://community.qlik.com/t5/QlikView/Resident-load-problem/m-p/185475#M49939 2009-09-15T14:44:37Z