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,
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 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.
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.
- 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
