I wanted to sum up the values of all rows of a field in an attribute table but couldn’t figure out how to do this in FME.
In ArcGIS, this can be done using the command “Summary Statistics”
Thank you
Best
Jamal
Solved
The equivalent tool of ArcGIS’s “Summary Statistics” in FME,
+5The equivalent tool of ArcGIS’s “Summary Statistics” in FME,
Best answer by takashi
Hi Jamal,
View original
I think the Aggregator (using "Attributes to Sum" parameter) is convenient to calculate sum of attribute(s).
If you need to calculate some other fundamental statistics values simultaneously - e.g. min, max, median, mode, average, standard deviation etc., consider using the StatisticsCalculator.
Takashi
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.
- Best Answer
Hi Jamal,
I think the Aggregator (using "Attributes to Sum" parameter) is convenient to calculate sum of attribute(s).
If you need to calculate some other fundamental statistics values simultaneously - e.g. min, max, median, mode, average, standard deviation etc., consider using the StatisticsCalculator.
Takashi
I don't think the AreaOnAreaOverlayer is necessary.
I guess that you intend to merge "BoundaryArea" to each building by the transformer. But, if so, you can control the merging operation using the "Merge Attributes" parameters group of the Clipper.
+5Many thanks Takashi,
Here I wanted the output of the summery to appear in form of table (the same way as in ArcGIS), is this possible in FME?
+5
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.