Skip to main content
Question

Grouping in FME

  • January 21, 2025
  • 3 replies
  • 126 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+12
  • 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+60
  • 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

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.