Explain Main use of resident key word in qlikview?

[#1]

Explain Main use of resident key word in qlikview?

[#2]

" Resident " keyword is used if data has to be loaded from a previously loaded table.

[Miguel_Angel_Baeyens · Accepted solution]

Ellaborating a bit what Rishi says, think of a mapping table you want to apply to your invoices based on Customer information.

First, you load all Customer information

Customers:LOAD CustomerID, CustomerName, CustomerCountry;SQL SELECT * FROM Customers;

Now say you want to get the ID and Country

CustomerCountry:LOAD CustomerID, CustomerCountryRESIDENT Customers; // It's not pulling from database, but from the table you already loaded

Instead of querying again the database or the file, you get the results form the already loaded table. In my experience, resident loads are quite slow, but they may be more comfortable when you do a lot of transformation in your load script.

Hope that helps.

[suniljain]

it create virtual copy of existing table.

if you access data from virtual table the execution speed is fast compared to original table.

[#5]

Can we make selections based in conditions here? Like, data related to particular CustomerID.

[#6]

thanks