Multiple Loads Execution Flow

[#1]

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!

[whiteline · Accepted solution]

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.