Resident Load

[#1]

Hi,

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

Can any one explain with example?

@Sub2u

[ajaykumar1]

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

[senpradip007]

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;

[tresesco]

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.

[engishfaque]

Dear Sub2a,

Kindly find attached documents for clear and better understanding.

Kind regards,

Ishfaque Ahmed

[vardhancse]

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.

[#7]

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

[#8]

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

[#9]

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.

[ashfaq_haseeb]

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