Integrate Software AG Products Using Digital Event Services : MashZone NextGen Help : Appendix : Operators : Data transformation operators : Aggregate : Parameters
Parameters
The following parameters are available.
Action
Result
Dimension column
Name of dimension column.
Source: Source table
Data type: Date, Number, or Text
Default value: {None}
Specification: Optional
Aggregation column
Name of the column to be aggregated.
Source: Aggregation column is transferred from the source table.
Data type: Number
Default value: {None}
Specification: Optional
Aggregation type
Aggregation type for the column to be aggregated: Average value, Sum, Minimum, Maximum, Count, First row and Last row.
Default value: Average value, if aggregation column selected.
Specification: Mandatory, if aggregation column selected.
Weighting
If the aggregation type is Average value or Sum, a numerical column for weighting of the rows can be specified for each column to be aggregated.
Specification: Optional
Copyright © 2017 Software AG, Darmstadt, Germany.

Product LogoContact Support   |   Community   |   Feedback