Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Explain Main use of resident key word in qlikview?

Explain Main use of resident key word in qlikview?

1 Solution

Accepted Solutions
Miguel_Angel_Baeyens

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.

View solution in original post

5 Replies
Not applicable
Author

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

Miguel_Angel_Baeyens

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
Master
Master

it create virtual copy of existing table.

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

Not applicable
Author

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

Not applicable
Author

thanks