Skip to main content
Question

Grouping in FME

  • January 21, 2025
  • 3 replies
  • 91 views

ohashkii
Contributor
Forum|alt.badge.img+8

Hi

I am having an excel sheet like below. I need to group them in Field name route and assign a value for route field .

let's say (routeNo)  or any other unique value.

the grouping is based on finding a value that is considerable above of other previous records 

below is 48. which is very big than other previous ones.

Any help is highly considered. 

Route 1

Route 2

 

3 replies

koulsoum
Contributor
Forum|alt.badge.img+10
  • Contributor
  • January 21, 2025

Hi ​@ohashkii ,

you can use a Sorter (grouping by Route) to sort your attribute ‘defy’ according to the Order ‘Descending’. And a Sampler ( same group by Route) to take the highest value, you can choose First N-feature.

Hoping this will helps you


geomancer
Evangelist
Forum|alt.badge.img+47
  • Evangelist
  • January 21, 2025

Use 'Enable Adjacent Feature Attributes’ in Attributemanager to look at the value of the previous feature.

See the attached workspace.


ohashkii
Contributor
Forum|alt.badge.img+8
  • Author
  • Contributor
  • January 22, 2025
geomancer wrote:

Use 'Enable Adjacent Feature Attributes’ in Attributemanager to look at the value of the previous feature.

See the attached workspace.

Thank you very much...works well.


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