Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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