Skip to main content
Question

Statistics Calculator

  • November 21, 2018
  • 3 replies
  • 30 views

Forum|alt.badge.img

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

ebygomm
Influencer
Forum|alt.badge.img+44
  • Influencer
  • 3429 replies
  • November 21, 2018

Have you tried without the StringFormatter?


mark2atsafe
Safer
Forum|alt.badge.img+56
  • Safer
  • 2554 replies
  • November 21, 2018

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?


Forum|alt.badge.img+2
  • 1891 replies
  • November 22, 2018

@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