topic drop table does not work for me in QlikView

drop table does not work for me

ananyaghosh — Sun, 22 Feb 2015 03:46:25 GMT

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.

Re: drop table does not work for me

Sun, 22 Feb 2015 04:43:32 GMT

u can give like:

drop table [Old Item Details];

drop table Sort_Sales;

i guess it should work.

Re: drop table does not work for me

Sun, 22 Feb 2015 05:24:14 GMT

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.