Integrate Software AG Products Using Digital Event Services 10.4 | Integrate Software AG Products Using Digital Event Services | MashZone NextGen Help | Appendix | Operators | Data transformation operators | Aggregate | Behavior
 
Behavior
Combines rows if identical values occur multiple times in specified dimension columns. The numerical values in the remaining columns are combined using Average, Sum, Minimum, Maximum, or Number.
One or more numerical columns in a table are aggregated using no, one or several dimension columns. In all rows that have the same values in all dimension columns, the values in the columns to be aggregated are combined into one row based on an aggregation rule, i.e., the result contains one row for each combination of dimension columns. This also applies if no columns are specified for aggregation. If no dimension column is specified, only a single row is created and all values in the columns to be aggregated are combined to a single value for each column. No rows are created for combinations that do not occur in the original table.

Copyright © 2019 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release