Hi Vijay,
Please check this. Let me know if you did not not understand.
Loading data from a previously loaded table
There are two ways to load and transform data from a table that already has been loaded.
- Resident LOAD - where you use the Resident predicate in a subsequent LOAD statement to load a new table.
- Preceding load - where you load from the preceding LOAD or SELECT statement without specifying a source.
- Resident or preceding LOAD?
- Resident LOAD
-
Resident or preceding LOAD?
In most cases, the same result can be achieved by using either method. A preceding LOAD is generally the faster option, but there are some cases where you need to use a Resident LOAD instead:
- If you want to use the Order_by clause to sort the records before processing the LOAD statement.
- If you want to use any of the following prefixes, in which cases preceding LOAD is not supported:
- Crosstable
- Join
- Intervalmatch
Resident LOAD
You can use the Resident predicate in a LOAD statement to load data from a previously loaded table. This is useful when you want to perform calculations on data loaded with a SELECT statement where you do not have the option to use Qlik Sense functions, such as date or numeric value handling.
Example:
In this example, the date interpretation is performed in the Resident load as it can't be done in the initial Crosstable LOAD.
PreBudget: Crosstable (Month, Amount, 1) LOAD Account, Jan, Feb, Mar, …
From Budget; Budget: Noconcatenate
LOAD Account, Month(Date#(Month,’MMM’)) as Month, Amount Resident PreBudget;
Drop Table PreBudget;
https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/load-data-from-previousl...
