Question

Sumifs/Averageifs in FME

  • 3 August 2018
  • 2 replies
  • 6 views
E

Hi,

Is there a way of being able to replicate excel's sumifs/Averageifs functions in FME?

I have two tables, the first table has unique ID's and the second table contains data which I need to aggregate. Is there a transformer where I can use the unique values in table 1 to match against the data in table 2 to perform a Sumifs?

Thanks in advance.

2 replies

owen
Badge +1

Hello, yes you can use the 'group by' function on the statistics calculator. Might need to join your tables, although not clear on that from your post. Owen

E

Thanks for your help!

Reply


Community Stats

28,729
Posts
109,527
Replies
36,565
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.