drop table does not work for me

[ananyaghosh]

Hi,

Below is the script

[Old Item Details]:

NoConcatenate  LOAD [Order ID],

     OrderDate,

     Region,

     Rep,

     Item,

     Units,

     [Unit Cost],

     Total

FROM

(qvd);

Sort_Sales:

LOAD * Resident [Old Item Details] Order By OrderDate;

LET vMaxOrderDate = Peek('OrderDate', -1, 'Sort_Sales');

Drop Tables [Old Item Details], 'Sort_Sales';

Gives me error 'table not found', when I use  'Sort_Sales' as my table name, but when I use only [Old Item Details] , it works fine.

[#2]

u can give like:

drop table [Old Item Details];

drop table Sort_Sales;

i guess it should work.

[#3 · Accepted solution]

NoConcatenate  has to be used with table Sort_Sales:

Sort_Sales:

NoConcatenate 

LOAD * Resident [Old Item Details] Order By OrderDate;

Since NoConcatenate  is not been given all the records are getting appended  to [Old Item Details] table, since all the fields are same, and Sort_Sales is not generated at all, hence showing error while dropping it.