Skip to main content
Solved

Rearrange and sum up attributes/values

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.

 

View original
Did this help you find an answer to your question?

3 replies

jdh
Contributor
Forum|alt.badge.img+28
  • jdhContributor
  • Contributor
  • 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+7
  • sipsysighContributor
  • Contributor
  • 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
  • May 14, 2019
sipsysigh wrote:

 

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!

Reply


Helpful Members This Week

Community Stats

31,300
Posts
118,693
Replies
38,878
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.