Ansicht
Dokumentation

ABENFOR_GROUP_BY_LEVELS_ABEXA - FOR GROUP BY LEVELS ABEXA

- Grouping with FOR in Group Levels

This example demonstrates simple group level processing using GROUP BY in a FOR expression.

Source Code

Execute

Description

This example works in the same way as the corresponding executable example for LOOP AT ... GROUP BY, but uses the expression FOR GROUPS ... OF for a table reduction with REDUCE instead of the group loop. In both cases, the group key after GROUP BY is constructed in exactly the same way.

The result of the table reduction is a structure to which the total of the numeric columns is written. The subtotals and the group members are written to the local helper variables sum and members using a further table reduction and a table comprehension. This table reduction table comprehension could also be used in the executable example for LOOP AT ... GROUP BY instead of the member loop. loop.