topic Re: Delete tables (QVD) in QlikView

Delete tables (QVD)

Tue, 07 Jan 2014 11:49:57 GMT

Hi all,

I'm creating a table with 'store into' in order to make a later load and concatenate.

how can I, from the script, delete this table when I complete the concatenation?

Thanks,

Boris

Anonymous — Tue, 07 Jan 2014 11:50:49 GMT

drop table YourTable ;

tresB — Tue, 07 Jan 2014 11:51:29 GMT

Try like:

EXECUTE CMD.EXE /C del "yourqvd.qvd";

Tue, 07 Jan 2014 11:52:32 GMT

I'm not talking about in memory table, it an already created QVD

edwinmatlapeng — Tue, 07 Jan 2014 11:54:53 GMT

drop table 'tablename' should work! this will delete both a memory table and an existing QVD!

Tue, 07 Jan 2014 12:11:27 GMT

Sorry, but it doesn't work.

QV documentation states that drop table is for in memory tables.

Also, I tried a test and it didn't delete the table.

thank you anyway.