Data Load From Previously Loaded Data

In QlikView, you can load data from previously loaded data by using the resident load function. The resident load function allows you to load data from a previously loaded table into a new table without having to re-import the data from the source.

To use the resident load function, you will need to specify the name of the previously loaded table and the fields you want to include in the new table. Here is an example of a resident load statement:

RESIDENT [Previously Loaded Table] (Field1, Field2, Field3);

In this example, the resident load function loads the fields “Field1”, “Field2”, and “Field3” from the previously loaded table “Previously Loaded Table” into a new table.

The resident load function can be useful when you want to perform additional data transformations or calculations on data that has already been loaded into QlikView.

I hope this helps!

In QlikView, it is possible to load data from previously loaded data, also known as resident loading. This is done using the “LOAD” statement and the “RESIDENT” keyword.

The “RESIDENT” keyword is used to load data from a previously loaded table. This can be useful when you need to create a new table based on data from an existing table, or when you want to join data from multiple tables.

For example, the following script loads data from a previously loaded table “orders” and creates a new table “orders_region”:

vbnetCopy code
LOAD * RESIDENT orders;
LOAD region, sum(sales) as sales_by_region
RESIDENT orders
GROUP BY region;

In the above script, the first “LOAD” statement loads all fields from the “orders” table. The second “LOAD” statement loads the “region” field and calculates the “sales_by_region” field by summing the “sales” field and grouping the data by “region”.

It’s also possible to use the “WHERE” clause in the “LOAD” statement to select specific data from the previously loaded table. For example, the following script loads only the data from the “orders” table where the “region” field is equal to “West”:

javaCopy code
LOAD * RESIDENT orders WHERE region = 'West';

In addition to loading data from previously loaded tables, it’s also possible to use other types of data, such as variables and expressions, in the “LOAD” statement.

Resident loading is a powerful feature of QlikView, allowing you to easily create new tables based on existing data, join data from multiple tables, and filter data based on specific criteria.

In summary, resident loading in QlikView enables you to load data from previously loaded data, by using the “LOAD” statement and the “RESIDENT” keyword. This can be useful when you need to create a new table based on data from an existing table, or when you want to join data from multiple tables. It also allows you to use the “WHERE” clause to filter data based on specific criteria.