Skip to main content
Solved

Rearrange and sum up attributes/values

  • May 13, 2019
  • 3 replies
  • 425 views
M

Hi there

My first post here, so be gentle.

I have made FME workbench to calculate different kind of attributes from DWG file (line lengths, areas etc.) and export the results to Excel file. The idea is that the workbench calculates the chosen things from DWG file and distributes them according to the divider area. Calculating part is working like a charm, but I have a problem with arranging results to form I want. It is hard to explain (in English what I mean, so here is the picture that hopefully explain what iam looking after. I have spent way too much time to solve this problem by myself, so I am more than happy if someone could push me to right way.

Thanks in advance!

Best answer by sipsysigh

 

Hi,

I would agree with @jdh's answer. If you are a relative new comer to FME then I think that the StatisticsCalculator is probably an easier transformer to get to grips with and understand.

If you want to use the StatisticsCalculator then you might want to consider the following parameters:

Setting the Group By to "CAD LAYER" and "Area (Divider)" will ensure that if the features have the same "CAD LAYER" and "Area (Divider)" values then the "Area (m2)" will be summed and counted appropriately. If you just Group By "CAD LAYER" then a feature with Area 1, Layer 1 would be grouped with a feature with Area 2, Layer 1 which you might not necessarily want.

 

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

jdh
Contributor
Forum|alt.badge.img+37
  • jdhContributor
  • Contributor
  • 2002 replies
  • May 13, 2019

You'll want to use either an aggregator or a statisticsCalculator. In either case you'll want to set the group-by parameter to CAD LAYER.

sipsysigh
Contributor
Forum|alt.badge.img+12
  • sipsysighContributor
  • Contributor
  • 37 replies
  • Best Answer
  • May 13, 2019

 

Hi,

I would agree with @jdh's answer. If you are a relative new comer to FME then I think that the StatisticsCalculator is probably an easier transformer to get to grips with and understand.

If you want to use the StatisticsCalculator then you might want to consider the following parameters:

Setting the Group By to "CAD LAYER" and "Area (Divider)" will ensure that if the features have the same "CAD LAYER" and "Area (Divider)" values then the "Area (m2)" will be summed and counted appropriately. If you just Group By "CAD LAYER" then a feature with Area 1, Layer 1 would be grouped with a feature with Area 2, Layer 1 which you might not necessarily want.

 

M
  • mahtaja
  • Author
  • 2 replies
  • May 14, 2019

 

Hi,

I would agree with @jdh's answer. If you are a relative new comer to FME then I think that the StatisticsCalculator is probably an easier transformer to get to grips with and understand.

If you want to use the StatisticsCalculator then you might want to consider the following parameters:

Setting the Group By to "CAD LAYER" and "Area (Divider)" will ensure that if the features have the same "CAD LAYER" and "Area (Divider)" values then the "Area (m2)" will be summed and counted appropriately. If you just Group By "CAD LAYER" then a feature with Area 1, Layer 1 would be grouped with a feature with Area 2, Layer 1 which you might not necessarily want.

 

Thanks sipsysigh, StatisticsCalculator did the job!

Community Stats

32,080
Posts
121,820
Replies
39,714
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.