Qlik Community

QlikView Integrations

Discussion Board for collaboration on QlikView Integration.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
srinu1331
Contributor III
Contributor III

preciding load vs resident load

Difference between Preceding load and Resident load

2 Replies
vinieme12
Champion III
Champion III

there is ample of content available on the related topics, you can search them on the forum

Have a good read

https://community.qlik.com/search.jspa?q=preceding+load+resident+load

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
surendraj
Specialist
Specialist

Preceding Load

Resident load and precedding load

Precedding load creates only one table.because we can do the manipulations/aggregations/aliases with in the same load statement with another load statement.Preload is used to add dimensions and facts to the current table.

Resident load is also used to reuse already in-memory loaded tables. so here physically two table are created.

So preceding load is best practice in qlikview when comared to resident load.

Example:

Resident load:

Tab1:

load empname,

        salary,

        emp id

from----------(.txt)

tab2:

load max(salary) as maxsal,

        count(emp id) as count

resident tab1; //Here we used the salary and empid fields from tab1.so we need to use keyword resident.

here in data model physically both tab1 and tab2 are presented.

Precedding load:

tab1:

load  *,max(salary) as maxsal,

        count(emp id) as count group by empname;

load empname,

        salary,

        emp id

from----------(.txt)


If you want all the fields,you can put * .here automatically tab2 is droped itself.(without exicuting the drop command even).so here only 1 table is presented in data model.

Hope it helps!!