topic Re:Resident load in QlikView

Re:Resident load

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

Hi all,

when we are doing the resident load in qlikview can anyone explain the where condintion usage in resident load

Thanks

Vijay Kumar

Re:Resident load

BalaBhaskar_Qlik — Mon, 23 Jul 2018 17:09:36 GMT

Resident Load can be used to load data from a previously loaded table. In Resident Load, we can do a calculation or transformation. It is very simple to load an existing field and table also. It is a highly important feature of QlikView because by using Resident Load, we perform a calculation on an existing field and table also.

Small Example:

City:

Load * inline

[

Name,Sales,Year

Africa,250,2011

Montana,580,2013

Durban,489,2017

];

TotalCheck:

Load

Name,

Sum(Sales) as TotalValue

Resident City

Group by Name;

Drop Table City;

Re:Resident load

BalaBhaskar_Qlik — Mon, 23 Jul 2018 17:10:09 GMT

Check this:

https://www.c-sharpcorner.com/UploadFile/35fef0/resident-load-in-qlikview/

Re:Resident load

agarwalrits13 — Tue, 24 Jul 2018 01:08:37 GMT

Hi Vijay,

Below is the qlikview Help link which gives detail information about resident load.

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/load-data-from-previously-loaded-table.htm

Re:Resident load

qlikviewwizard — Tue, 24 Jul 2018 02:23:15 GMT

Hi Vijay,

Please check this. Let me know if you did not not understand.

Loading data from a previously loaded table

There are two ways to load and transform data from a table that already has been loaded.

Resident LOAD - where you use the Resident predicate in a subsequent LOAD statement to load a new table.
Preceding load - where you load from the preceding LOAD or SELECT statement without specifying a source.
Resident or preceding LOAD?
Resident LOAD

Resident or preceding LOAD?

In most cases, the same result can be achieved by using either method. A preceding LOAD is generally the faster option, but there are some cases where you need to use a Resident LOAD instead:

If you want to use the Order_by clause to sort the records before processing the LOAD statement.
If you want to use any of the following prefixes, in which cases preceding LOAD is not supported:
- Crosstable
- Join
- Intervalmatch

Resident LOAD

You can use the Resident predicate in a LOAD statement to load data from a previously loaded table. This is useful when you want to perform calculations on data loaded with a SELECT statement where you do not have the option to use Qlik Sense functions, such as date or numeric value handling.

Example:

In this example, the date interpretation is performed in the Resident load as it can't be done in the initial Crosstable LOAD.

PreBudget: Crosstable (Month, Amount, 1) LOAD Account, Jan, Feb, Mar, …

From Budget; Budget: Noconcatenate

LOAD Account, Month(Date#(Month,’MMM’)) as Month, Amount Resident PreBudget;

Drop Table PreBudget;

https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/load-data-from-previously-loaded-table.htm

Re:Resident load

MindaugasBacius — Tue, 24 Jul 2018 05:39:14 GMT

In Resident load Where condition can be used the same as in Load statement.

Re:Resident load

BalaBhaskar_Qlik — Wed, 25 Jul 2018 06:42:49 GMT

If you got the answer, mark it as Answered and close the thread.

Re:Resident load

pintucs20 — Fri, 27 Jul 2018 08:57:34 GMT

Hi Vijay,

Yes, you can use before and after drop table, its not matter when you want to use .

its is working in both situation.

Thanks