Solved

calculate sum value of some rows which have identical row id in one row using aggregator

  • 9 September 2022
  • 2 replies
  • 61 views

Badge +4

I have a table in which some rows have identical values. I would merge the identical rows into one by using aggrator.

I want the sum of row values ​​to be written to a new row.

the aggragator does not calculate a sum of the values.

Attached you will find the pictures that may help you to better understand my description.

aggragator_Problemcolumn Anzahl_Gas_HA must be 2177 after using aggregator.

icon

Best answer by caracadrian 9 September 2022, 13:57

View original

2 replies

Badge +20

Set GroupBy to Zone and Attributes to Sum Anzahl_Gas_HA:

Aggregator GropuBy SumIf the sum isn't coming out right send the features through AttributeValidator with Anzahl_Gas_HA Type is Integer and check if there are no strings mixed with the numbers.

Badge +4

Set GroupBy to Zone and Attributes to Sum Anzahl_Gas_HA:

Aggregator GropuBy SumIf the sum isn't coming out right send the features through AttributeValidator with Anzahl_Gas_HA Type is Integer and check if there are no strings mixed with the numbers.

Super. Thanx alot :)

Reply