Appendix : Operators : Data transformation operators : Aggregate : Examples
Examples
The following table is to be aggregated based on the Dim 1 and Dim 2 columns.
Dim 1
Dim 2
Values 1
Values 2
Weight (values 2)
A
X
1
2
3
B
Y
2
4
4
C
Z
5
6
3
A
X
7
8
4
B
Y
9
10
3
C
Z
11
12
4
The sum is to be calculated for the Values 1 column and the average for the Values 2 column. The Weighting (values 2) column is used for weighting the Values 2 column one row at a time.
Result
Dim 1
Dim 2
Sum (values 1)
Average (values 2)
A
X
8 (1+7)
5,43 (2*3 + 8*4)/(3+4)
B
Y
12 (3+9)
6,57 (4*4 + 10*3)/(4+3)
C
Z
16 (5+11)
9,43 (6*3 + 12*4)/(3+4)
Copyright © 2013-2017 Software AG, Darmstadt, Germany.
Product LogoContact Support   |   Community   |   Feedback