Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

API QUESTION DROP TABLE

Dear all,

I have a qvw file only for reload and execute macros.

After execute all I want to drop all tables.

I have that sub but i don't know how ho drop tables:

Sub Droptables

set doc=ActiveDocument

for i=0 to doc.GetTableCount-1

name = doc.GetTableName(i)

'doc.deletetable(name)

next

end sub



5 Replies
prieper
Honored Contributor II

API QUESTION DROP TABLE

Why don't you do it in the script:

DROP TABLE YourTable;
or
DROP TABLES YourTable1, YourTable2;

HTH
Peter

Luminary
Luminary

API QUESTION DROP TABLE

Hi,

Not sure you can do this via the API. However, what is stopping you doing it at the end of your script?

Regards,

Stephen

Not applicable

API QUESTION DROP TABLE

Dear,

after reload, I'm executing a Macro that is doing some export.

After that, I want to clear all the data and save the file.

File is loading from another QVW and it's near 2 Gigs, and I don't want to have all the data on the file because it's reloading every day and i don't need the data.

Best regards.

llauses243
Contributor III

API QUESTION DROP TABLE

Hi Jordi ,

If drop all tables the document (.qvw) useful zero only schema

Left macro for clear data & save document , to apply OnClose

Good luck, from Spain, Luis (0034657486722)

Not applicable

API QUESTION DROP TABLE

Dear Luis,

thanks for your answer but How I can execute macro OnClose (I don't have that option to select on document propierties)

Saludos desde Barcelona.

Community Browser