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
  • 280 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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

caracadrian
Contributor
Forum|alt.badge.img+23
  • caracadrianContributor
  • 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
  • arash_hokmContributor
  • Author
  • Contributor
  • 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.

Super. Thanx alot :)

Community Stats

32,154
Posts
122,043
Replies
39,812
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.