All
To echo Michael's requirement I would like a case item option for the StatisticsCalculator transformer, so you get a set of statistics for each value of the case item. This would handle Michael's requirement too. Showing my ArcInfo background here.. Bruce. Bruce Harold Geographic Information Solutions <http://www.gis.co.nz> www.gis.co.nz Ph. (64) (0) 9 537 3247 Mb. (+64) (0) 21 2995995 _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of mhabarta Sent: Saturday, 31 March 2007 3:09 a.m. To: [email protected] Subject: [fme] How to do a count with GROUP BY Hello experts ... For statistics sake I need to count features and group them by an attribute. Just like the SQL SELECT count(*) GROUP BY ... With Aggregator I can do this BUT this Aggregator does way too much and crashes if I try this on several million features. Any ideas for a downsized solution ... StatisticsCalculator counts BUT cannot GROUP ... AttbriuteAccumulator cannot COUNT ... BTW: I also filed a BUG report, that Aggregator is factors slower in FME2007 than in FME2006GB Thanks for any ideas Michael
