Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashokkumar
Contributor II
Contributor II

what is the Resident load

 
1 Solution

Accepted Solutions
brunobertels
Master
Master

Resident load in qlik is loading data from previously loaded table.

 

Following is example:

 

table1:

load * inline []

Country,Sales

india,10000

china,20000

japan,30000

Usa,40000

;

 

table2:

load * resident table table1 where sales = 10000;

 

 

Explanation:

 

In table2 only one records will be loaded from table 1 because of where condition.

 

i.e for india sales = 10000

View solution in original post

1 Reply
brunobertels
Master
Master

Resident load in qlik is loading data from previously loaded table.

 

Following is example:

 

table1:

load * inline []

Country,Sales

india,10000

china,20000

japan,30000

Usa,40000

;

 

table2:

load * resident table table1 where sales = 10000;

 

 

Explanation:

 

In table2 only one records will be loaded from table 1 because of where condition.

 

i.e for india sales = 10000