mobileNavlogo
headerlogo

Resident Load in Qlikview

19 September, 2018

Ratings

Related Blogs

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 ;

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .