topic Remove table from memory without refresh in QlikView

Remove table from memory without refresh

Anonymous — Wed, 21 Jul 2010 16:26:59 GMT

Is it possible to remove a table from memory without modifying the load script & refreshing data? The reason I ask is that the application is loaded in laptop memory, however one huge table is causing memory issues & no data shows up. I want to remove this big table so that the rest of the application works. I am on the road & do not have the connectivity to the database & hence modify script / refresh data is not an option.

Any help?

Thanks,

Dinesh.

Remove table from memory without refresh

Wed, 21 Jul 2010 16:55:21 GMT

Can you modify the script and do a Partial Reload? If you add the following to your script:

REPLACE DROP TABLE BigTable;

Make sure that is the only command with the REPLACE prefix. Then do a Partial Reload. On a Partial Reload, only commands with the REPLACE prefix will run. I did some testing on the app I'm working on and it seemed to work fine. I would make a duplicate copy of the file before you try it, just in case.

Another option is Reduce Data, but I don't know if it would be possible to get rid of just one table using that method.

Remove table from memory without refresh

rlp — Fri, 30 Mar 2012 10:09:34 GMT

Be careful:

You should write REPLACE ONLY so that the table will not be dropped during standard load...