FME(R) 2017.1.2.1 (20180117 - Build 17725 - WIN32)
I have a data set in SDE that contains multiple records for a single pipe segment. Pipe size (CONDUIT_WI) is an attribute that can change in these records. Below is the transformer configuration that I have attempted to get the max value of the count attribute. But I keep getting empty results. I have tried different configurations with no success. Any Help is much appreciated.
+10
Have you tried without the StringFormatter?
+25
Can you inspect the data at the previous steps (the Counter and StringFormatter) to ensure that what is going into the StatsCalculator is correct? Also try turning off Input Ordered by Group in the StatsCalculator (cause if it isn't ordered, that would result in empty results). Also, does the log window report any warnings or errors?
+2
@jim I'm not quite sure if you want the count of the number of different diameters or the diameter with the largest number of counts, but I have a feeling that a combination of Aggregator and ListHistogrammer may be what you could use.
Test workspace attached (2018): CONDUIT_COUNT.fmw
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
