Aggregate Specification

Aggregate specification denotes a list of group_by columns when aggregation is part of the transformation.

Syntax:

aggregate_specification ::= GROUPBY column_list ;

Example:

IMPORT SOURCE CUSTOMERS
IMPORT SOURCE COUNTRIES

DEFINE VERSIONED DATASET GAMING_CUSTOMER_REACHED_G
 ROWSOURCE CUSTOMERS INNER JOIN COUNTRIES ON (CUSTOMERS.COUNTRY_ID = COUNTRIES.COUNTRY_ID)
 THIS = COUNTRIES[COUNTRY_REGION,COUNTRY_SUBREGION];
 THIS[REACHED_VOLUME] = COUNT(CUSTOMERS.CUST_ID);
 GROUPBY[COUNTRY_REGION,COUNTRY_SUBREGION];
 PRIMARYKEY[COUNTRY_REGION,COUNTRY_SUBREGION];
END