Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • I am trying to count the number of features based on 2 filters but my expressions are not returning what I need.

My data has a 'label' attribute, example - TCY/D/N3000000. I split this to just get the 'TCY' and created a list, then an attribute (DA_abrv) based on that list value. Now I need to count how many features are within my dataset containing 'TCY' in the label and another attribute value, example: (status = 6 and DA_abrv = 'TCY'). Consented is 'status = 6', Engaged is 'status = 2'

 

My output needs to look like this:

 

DA Consented Engaged

TCY 5 1

BGS 10 12

LAY 30 8

 

I have tried setting a conditional value in the writer to return this but it's not working. Any help would be greatly appreciated.

 

I would use the Counter transformer with the Group By parameter set to DA_abrv, and your second attribute. You will need to set the Count Scope to Local in order to enable the Group By option. After that I would use the StatisticsCalculator to get the max count of _count for your report.

Reply


Community Stats

30,162
Posts
114,512
Replies
37,820
Members
Terms & ConditionsCookie settings
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.