Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am new to Qlikview
How to Create Resident Load?
Plz Help.
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 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
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 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
First load a table from some source
FirstTable:
LOAD * INLINE [
FieldA
a
b
c];
Then use a resident load to create a new table with data from the first table:
NextTable:
LOAD
FieldA as FieldB
RESIDENT
FirstTable
;
Resident LOAD - When you load data from existing table in the memory.
Let suppose you load data from Excel file with this script into table Sample_Data:
Sample_Data:
LOAD
[Dimension A],
[Dimension B],
[Measure X]
FROM [lib://Desktop/Sample Data.xlsx]
Now you want to make some modification into the same table and reload again, you can use resident load and drop the original table.
Sample_Data_Transformed:
LOAD
[Dimension A],
[Dimension B],
[Measure X]*365 as [Yearly Measure]
Resident Sample_Data;
Drop Sample_Data;