Multiple Loads Execution Flow

Thu, 29 Aug 2013 07:22:12 GMT

Hi,

In the following script which load statement is executed first. Whether the VIN in the KEY is made first according to the first load statement or the VIN is grouped according the second load statement first.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

ServiceRetention:

Load *,

'ServRet' AS [Trn Type],

VIN & ' | ' & [Selling Dealer] AS KEY;

Load

VIN,

firstvalue(DEALER_CD) AS [Selling Dealer]

RESIDENT [Service Retention3]

GROUP BY VIN;

DROP TABLE [Service Retention3];

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks!

Re: Multiple Loads Execution Flow

whiteline — Thu, 29 Aug 2013 08:39:34 GMT

Hi.

The last one with aggregation by VIN is executed first. Then the KEY is generated for each unique VIN.

I think you could just try it in a separate exaple see what happends.

topic Multiple Loads Execution Flow in QlikView

Multiple Loads Execution Flow

Re: Multiple Loads Execution Flow