Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
arethaking
Creator II
Creator II

How to Create Resident Load?

Hi All,

I am new to Qlikview

How to Create Resident Load?

Plz Help.

1 Solution

Accepted Solutions
arvind1494
Specialist
Specialist

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

View solution in original post

4 Replies
arvind1494
Specialist
Specialist

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

arvind1494
Specialist
Specialist

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

Gysbert_Wassenaar

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

;


talk is cheap, supply exceeds demand
imsushantjain
Partner - Creator
Partner - Creator

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;