Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subroutine Store and Drop: error

Hi all,

i have this subroutine in the load script for Store all tables in qvd files and drop alla tables from qvw.

/*************************SUB ROUTINE***************************/

sub StoreQVD

let numTables = NoOfTables();

for i=0 to $(numTables)-1

let tt = TableName($(i));

store $(tt) into $(vPathQVD)\$(tt).qvd;

drop tables $(tt);

next i

end Sub;

/*************************CALL***************************/

call StoreQVD;

/*************************END***************************/

where numTables=12

It properly stored 12 qvd files ,but drops only 6 table.

WHY???

Thanks

MC

1 Reply
erichshiino
Partner - Master
Partner - Master

Hi, MC

Did you check the logs to identify the points where it drop the tables?

You can enable log files in the settings menu -> Document Properties -> General tab -> Generate log file

Regards,

Erich