Resident load problem

[#1]

Hello,

See the code below. For some reason the Resident load does not work.. TempTable is created and dropped but Tab2 is not being created.

Can someone tell me what I'm doing wrong?

Thanks, Sander

TempTable:
LOAD
 Verkooporders.Ordernr AS Ordernr,
 [Verkooporders.Document Type] AS Type

FROM ..\..\..\Datasources\QVD\Verkooporders\Verkooporders_NL.qvd (qvd)
WHERE [Verkooporders.Document Type] = 'Order';
LEFT JOIN
LOAD
 [Facturen.Ordernr_ factuur] AS Ordernr,
 [Facturen.Ordernr_ factuur] AS Ordernrfactuur,
 Facturen.Factuurnr AS Factuurnr

FROM ..\..\..\Datasources\QVD\Facturen\Facturen_NL.qvd (qvd)
WHERE ISNULL([Facturen.Ordernr_ factuur]) = 0;
Tab2:
LOAD * RESIDENT TempTable
WHERE ISNULL(Factuurnr)=0;
DROP TABLE TempTable;

[biester · Accepted solution]

Try a NOCONCATENATE LOAD * RESIDENT TempTable .

Rgds,
Joachim

[#3]

Thanks, Joachim!

That did the trick..

Regards, Sander