Skip to main content
Question

Aggregate and count the status in field using FME Workbench

  • November 8, 2023
  • 1 reply
  • 240 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+59
  • 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