Skip to main content
Question

Aggregate and count the status in field using FME Workbench

  • November 8, 2023
  • 1 reply
  • 197 views

aravi29
Contributor

I have two layers point and a polygon, I wanted to have the aggregate of a column name "Progress" with its respective polygon name and polygon id. The progress field in the point layer has the values namely 1, 2, 3, 4, 5 . The count is the total number of points inside the polygon. 

 

The result should be like this 

 

new 

I have currently done this process in FME 6uhshThe result is 

gaRGwHow to change the workbench to attain the desired result. Any leads will be helpful. Thank you. 

1 reply

geomancer
Evangelist
Forum|alt.badge.img+48
  • Evangelist
  • November 8, 2023

Some ideas to look into:

  • In the Aggregator, create a list and process that list with an ElementCounter
  • Replace the Aggregator with a StatisticsCalculator
  • Replace the SpatialFilter with an PointOnAreaOverlayer and use Overlap Count

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