Storing a dataset in a resident table

Anonymous — Thu, 10 May 2012 12:01:35 GMT

Hi,

I am doing a LOAD statement which produces a large dataset; I want to store that dataset for use in a second tab in the load script, but I don't want to store the dataset as a "physical" QVD, such as

STORE

RATINGS

INTO

(qvd);

Is it possible to somehow store this dataset in memory, i.e., a resident table? I tried this:

STORE

RATINGS

INTO

RATINGS_TABLE (qvd);

But the subsequent LOAD in the second tab failed ("Table not found").

Is the only way to make a previously-loaded dataset available for future use to store it as a physical QVD on the filesystem?

Many thanks,

Re: Storing a dataset in a resident table

jonathandienst — Thu, 10 May 2012 12:14:20 GMT

I don't quite understand your question. Storing to a qvd is for file storage. All the tables loaded into the model are in memory and available to the script after the LOAD statement, accessible with a LOAD ... RESIDENT.

To use LOAD ... RESIDENT, it is necessary to name the tables, like:

TableName:

LOAD ...

and then use later with

AnotherTable:

LOAD ID, Name, Description RESIDENT TableName;

Not sure if I answered your question though....

Jonathan

topic Re: Storing a dataset in a resident table in QlikView

Storing a dataset in a resident table

Re: Storing a dataset in a resident table