Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
Myself Vinoth
What is menat by Resident in Script which we use for Load?
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
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
The source is a QV table
Previously laoded from any other source (qvd, xls, txt, sal)
Fabrice
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.