How to Create Resident Load?

[arethaking]

Hi All,

I am new to Qlikview

How to Create Resident Load?

Plz Help.

[arvind1494]

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 · Accepted solution]

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

;

[imsushantjain]

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;