Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

arethaking
Contributor II

How to Create Resident Load?

Hi All,

I am new to Qlikview

How to Create Resident Load?

Plz Help.

1 Solution

Accepted Solutions
Highlighted
arvind1494
Valued Contributor

Re: How to Create Resident Load?

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

4 Replies
arvind1494
Valued Contributor

Re: How to Create Resident Load?

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

Highlighted
arvind1494
Valued Contributor

Re: How to Create Resident Load?

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

MVP & Luminary
MVP & Luminary

Re: How to Create Resident Load?

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
Partner
Partner

Re: How to Create Resident Load?

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;