MashZone NextGen 10.2 | 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 © 2013-2018 | 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