Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is meant by Resident?

Hi All

Myself Vinoth

What is menat by Resident in Script which we use for Load?

4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Resident load is used when you want to load some or full data of the table which is already loaded in QlikView.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
Not applicable
Author

HI vinoth ,

resident is nothing but taking the files from existing table and forming into one new table is called resident in qlikview

Regrads

M Manjunath

Not applicable
Author

The source is a QV table

Previously laoded from any other source (qvd, xls, txt, sal)

Fabrice

jagan
Partner - Champion III
Partner - Champion III

Hi,

Resident Load is used to reload previously loaded table.  Please find example below

Data:

LOAD

     Col1,

     Col2,

     Col3

FROM DataSource;

Note: Datasource may be Excel, TXT, CSV, XML or a Select query etc.

Temp:

LOAD

     Col1

RESIDENT Data;

In the above Load statement instead of loading data again from source file, we are loading data from previously loaded qlikview table.  Resident Load is bit faster than Normal load, because it is already in the memory.

Regards,

Jagan.