topic In Memory Tables in QlikView

In Memory Tables

paulferguson80 — Fri, 02 Oct 2009 22:18:53 GMT

I have created a load that pulls back about 16 million rows, and takes a couple of hours to run, however in my infinite wisdome, i have forgot to include the config.txt file to run the store commands to save these tables! whoops!

Does anyone know if there is any way of storing the in memory table i have created in the QVW file without having to rerun the entire script?

Many Thanks

Paul Ferguson

In Memory Tables

prieper — Fri, 02 Oct 2009 22:29:47 GMT

Give it a try with a "binary load" and then save the data as .qvd

Peter

In Memory Tables

Mon, 05 Oct 2009 21:59:00 GMT

Something I have done when I want to make a qvd file from data in an existing document is this:

1. Make a temporary change to the loadscript. At the very top of the loadscript add one or more STORE commands to save the large tables as qvd files.

2. Immediately following the STORE commands add an EXIT SCRIPT;

3. Now, from the File menu select PARTIAL RELOAD. This will run the STORE commands and then exit the script. If you've saved the document with the modified loadscript then you will want to edit the loadscript again and remove (or comment out) the added lines. If you never saved the document with the modified loadscript then just close the application without saving.

In Memory Tables

Wed, 21 Jul 2010 18:31:14 GMT

Excellent - works great!