Resident Load in Qlikview

Resident Load in QlikView

In some cases, we will need to read the same table more than once in a single script execution. This means, querying the database (or QVDs) and pulling data from it, and then reprocessing that same data after the first read in order to make it adequate for our data model. Since the data is being stored in RAM after each query during the script execution, we can use that RAM-stored data instead of going directly to the original data source. This is accomplished via a Resident load.

Resident Load is used for loading the data from previously loaded tables.

Ex:  Transact:
LOAD Year,
Month,
Day,
Sales,

CustID
FROM
[E:\Qlik View\sales data.xls]
(biff, embedded labels, table is Sheet1$);
Tab2:
load Year, Sales Resident Transact ;

Summary
Review Date
Reviewed Item
Resident Load in Qlikview
Author Rating
51star1star1star1star1star

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on Resident Load in Qlikview"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Support


    Please leave a message and we'll get back to you soon.

    3 + 5