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?
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.
