Skip to main content
Solved

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

  • September 9, 2022
  • 2 replies
  • 222 views

arash_hokm
Contributor
Forum|alt.badge.img+8

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.

Best answer by caracadrian

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.

View original
Did this help you find an answer to your question?

2 replies

caracadrian
Contributor
Forum|alt.badge.img+23
  • Contributor
  • Best Answer
  • September 9, 2022

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.


arash_hokm
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • September 9, 2022
caracadrian wrote:

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 :)


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings