Resident load?

[chethankumarn]

Plz explain the concept of Resident load?

Im not getting it.

[oknotsen]

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.

[chethankumarn]

Plz  explain with an example.

[jagan]

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.

[avinashelite]

check this :

LOAD data into QlikView

[HirisH_V7]

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

[manojkulkarni]

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.

[Anonymous]

Check these threads, will be helpful for you:

Resident load

Resident Load in QlikView

Types of loads in Qlikview

[engishfaque]

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