topic Resident Load in QlikView

Resident Load

Tue, 09 Sep 2014 05:00:05 GMT

Hi,

Can any one explain with Resident Load? what is the use of it?

Can any one explain with example?

@Sub2u

Re: Resident Load

ajaykumar1 — Tue, 09 Sep 2014 05:05:39 GMT

Hi Subba Reddy.,

In short Resident load is nothing but loading the data in one table from other table.It will be usefull when your creating the data model with various sources.

For detail description and e.g. refer the reference manual.

Regards,

Ajay

Re: Resident Load

senpradip007 — Tue, 09 Sep 2014 05:06:01 GMT

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

temp:

LOAD * Inline [

eid, eName, Amount

1, A, 10

2, B, 15

3, C, 20

4, D, 25

5, E, 30

1, A, 40

2, B, 45

3, C, 50

4, D, 55

5, E, 60

];

T1:

NoConcatenate

LOAD

eid,

eName,

Sum(Amount) AS Expense

Resident temp

Group By eName,eid;

DROP Table temp;

Re: Resident Load

tresB — Tue, 09 Sep 2014 05:11:34 GMT

Resident fetches data from memory(already loaded data).

Ex:

Tab1:

Load * from <yoursource>;

Tab2:

Load * Resident Tab1; // QlikView has Tab1 already loaded in memory so you don't have to get it from your original source, you can fetch it from memory.

Re: Resident Load

engishfaque — Tue, 09 Sep 2014 05:12:13 GMT

Dear Sub2a,

Kindly find attached documents for clear and better understanding.

Kind regards,

Ishfaque Ahmed

Re: Resident Load

vardhancse — Tue, 09 Sep 2014 05:14:18 GMT

When we want to create any calculated filed in the bank end, we can create using resident load.

Eg:

Select

A+B as d

Resident table1;

Drop table1;

After doing resident load, we need to drop the main table.

Re: Resident Load

Tue, 09 Sep 2014 06:18:12 GMT

Hi Ajay,

Thanks for your reply.

I have a data with temp1, again why i need to store in another table?

I hope its taking some more memory from RAM.

@Sub2a

Re: Resident Load

Tue, 09 Sep 2014 06:30:37 GMT

Hi Pradip,

Thanks for your reply.

Here i forgot to put "Drop Table Temp". Now it was showing 15 records in two tables..why ? can u explain this in depth...

@Sub2a

Re: Resident Load

Tue, 09 Sep 2014 06:33:54 GMT

Resident load is mainly used to transform the data. You can some up the fact over using group by.

Resident load fetch data from already loaded table i.e. table store in RAM.

Re: Resident Load

ashfaq_haseeb — Tue, 09 Sep 2014 06:34:02 GMT

Hi,

Have a look at below link for more concepts

2 Tables without join
Left join
Right join
Inner join
Outer join
Join
Concatenate
Flags
Resident
Auto concatenate

http://community.qlik.com/docs/DOC-6562

Regards

ASHFAQ

Re: Resident Load

maxgro — Tue, 09 Sep 2014 06:37:43 GMT

when to use a resident load?

when you want to sort

tmp:

load * from <yoursource>;

final:

noconcatenate

load * resident tmp

order by somefield1, somefield2, ....;

drop table tmp;

Re: Resident Load

ajaykumar1 — Tue, 09 Sep 2014 06:38:09 GMT

Hi,

That depends on your req.Lets say for eg you have stored the data in table1 from db and the same way you stored the data in table2 from other source.if After some calculations you have to make linkage between the Table1 and table2 then you no need to get the data from db again by connecting you can get directly from the all ready stored tables.(From Tresecco :QlikView has Tab1 already loaded in memory so you don't have to get it from your original source, you can fetch it from memory.)

In the real time scenarios we cant run the extractors any time as because of db update or FTP cases.(little complex)

I hope its clear.

Regards,

AJay

Re: Resident Load

senpradip007 — Tue, 09 Sep 2014 06:38:36 GMT

Tell your actual requirement. I think it would be better to understand from that perspective.

Re: Resident Load

Tue, 09 Sep 2014 06:47:49 GMT

Hi Pradip,

Thanks again. I tried with your given example.

DROP Table temp; -- forgotten command

I forgot the above command to write in edit script. Now it was showing 15 records. I checked in data model, here synthetic keys are created...why it was showing 15 records...

@Sub2a

Re: Resident Load

senpradip007 — Tue, 09 Sep 2014 06:57:09 GMT

Could you please upload your sample qvw?

Re: Resident Load

Tue, 09 Sep 2014 07:04:09 GMT

Hi Pradip,

Please find the attachment...

@Sub2a

Re: Resident Load

Tue, 09 Sep 2014 07:05:35 GMT

attachment

Re: Resident Load

Tue, 09 Sep 2014 07:11:42 GMT

Hi,

If you refer temp1 as a resident table, you may prefer to have some transformation or other opertaions on data of resident table, temp1. Hence you may need to have another load for that transformation step.

Thanks!

Re: Resident Load

senpradip007 — Tue, 09 Sep 2014 07:14:55 GMT

Your attachment is missing.

Re: Resident Load

Tue, 09 Sep 2014 07:18:24 GMT

Sorry.....Please check now..

@Sub2a