topic Re: Resident load? in QlikView

Resident load?

chethankumarn — Mon, 18 Jan 2016 11:49:44 GMT

Plz explain the concept of Resident load?

Im not getting it.

Re: Resident load?

oknotsen — Mon, 18 Jan 2016 16:01:31 GMT

With resident load you can load from a table that is already in memory ("already residing in memory"). So use a table that you loaded / created earlier in the run of the current script as a source table.

Re: Resident load?

chethankumarn — Tue, 19 Jan 2016 01:01:38 GMT

Plz explain with an example.

Re: Resident load?

jagan — Tue, 19 Jan 2016 01:18:11 GMT

Hi,

Please check below example where Resident Load is used with sample data

Customer:

Name, OrderDate

A, 1/1/2015

A, 1/1/2014

B, 1/2/2015

B, 1/3/2015

If you want to find the first order of the customer then we can use resident like below

Customer:

LOAD

FROM CustomerDataSource;

CustomerFirstOrder

LOAD

Name,

Min(OrderDate) AS First Order

Resident Customer; // Using resident because we already loaded the Customer data in previous Load/SQL statement.

This is one of the scenario for Resident Load, hope this helps you.

Regards,

Jagan.

Re: Resident load?

avinashelite — Tue, 19 Jan 2016 05:02:33 GMT

check this :

LOAD data into QlikView

Re: Resident load?

HirisH_V7 — Tue, 19 Jan 2016 05:04:01 GMT

Hi ,

Resident Load:

Loading data from already loaded Qlikview table is possible using Resident Load.
Transformations and Calculations can be performed in the resident load script.
Loading a existing field or a succeeding table is possible too.

For Example:

Employees:

Select Empname,

HireDate,

Salary,

Incentives

From Employee;

Load Empname,

Month(HireDate),

Salary + Incentives as ‘GrossSalary’

Resident Employees;

HTH,

Hirish

Re: Resident load?

manojkulkarni — Tue, 19 Jan 2016 05:20:33 GMT

Resident Load : Loading data from already loaded Qlikview table which is present in Memory. Transformation & calculations can be done using resident load & will be much faster with small set of data compare to physical load.

Re: Resident load?

Anonymous — Tue, 19 Jan 2016 06:10:36 GMT

Check these threads, will be helpful for you:

Resident load

Resident Load in QlikView

Types of loads in Qlikview

Re: Resident load?

engishfaque — Tue, 19 Jan 2016 09:59:54 GMT

Dear Chethan,

Resident is used if data should be loaded from a previously loaded table.

Example:

TempTable:

Select A,B,C,D from transtable;

NoConcatenate

ResidentTable:

Load A,B,month(C),A*B+D as E resident TempTable Order By A asc;

Kind regards,

Ishfaque Ahmed