topic Re: How to Create Resident Load? in QlikView

How to Create Resident Load?

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am new to Qlikview

How to Create Resident Load?

Plz Help.

Re: How to Create Resident Load?

arvind1494 — Wed, 01 Aug 2018 11:14:44 GMT

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

Re: How to Create Resident Load?

arvind1494 — Wed, 01 Aug 2018 11:16:39 GMT

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

Re: How to Create Resident Load?

Gysbert_Wassenaar — Wed, 01 Aug 2018 11:17:47 GMT

First load a table from some source

FirstTable:

LOAD * INLINE [

FieldA

c];

Then use a resident load to create a new table with data from the first table:

NextTable:

LOAD

FieldA as FieldB

RESIDENT

FirstTable

;

Re: How to Create Resident Load?

imsushantjain — Wed, 01 Aug 2018 11:27:14 GMT

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;