Skip to main content
Solved

Highest score overall

  • October 6, 2020
  • 5 replies
  • 21 views
jan_van_prooije
Contributor
Forum|alt.badge.img+1

Hi, i have a question which i think should be solvable with fme but i don't know the right transformer(s) to get the solution.

Maxithlon

 

 

I have this table with points and id's. I would like to know the best way to calculate the highest score (1+2+3) but without using one id twice.

Do you have any id how to solve this?

 

***

 

Some extra info:

 

Maxithlon 2

Calculation 1 is not valid, here the sheet pics just the highest values (but picks A twice (not allowed)

 

Calculation 2 Here it picks the value of A (10) because it is the highest value in the table, but overall it is not the highest accumulation of points.

 

Calculation 3 is what i am looking for, Here it picks the value's which calculates the heighest overall points for the table

 

Jan

Best answer by ebygomm

It's not actually something that's easily solvable in FME in my opinion

 

You could use an inlinequerier to create all possible permutations then add up the scores and sort and keep the highest. If you have lots of data then python is probably going to be a better option

Capture

 

 

 

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.

5 replies

danilo_fme
Celebrity
Forum|alt.badge.img+51
  • danilo_fmeCelebrity
  • Celebrity
  • 2077 replies
  • October 6, 2020

Hi @jan_van_prooije​ 

Did you try to use the transformer StatisticCalculator?

 

Thanks in Advance,

Danilo

Partner Solutial Brazil - www.solutial.com.br
jan_van_prooije
Contributor
Forum|alt.badge.img+1
  • jan_van_prooijeContributor
  • Author
  • Contributor
  • 4 replies
  • October 6, 2020

Hi @jan_van_prooije​ 

Did you try to use the transformer StatisticCalculator?

 

Thanks in Advance,

Danilo

Thanks for the advice! i tried to use it, but i'm not getting the results i want. (added some more info in the question).

jonas_nelson
Enthusiast
Forum|alt.badge.img+25
  • jonas_nelsonEnthusiast
  • Enthusiast
  • 109 replies
  • October 7, 2020

Perhaps https://hub.safe.com/publishers/pacific-spatial-solutions/transformers/listsubsetenumerator could help solving this?

(I'm not sure exactly HOW though).

ebygomm
Influencer
Forum|alt.badge.img+44
  • ebygommInfluencer
  • Influencer
  • 3427 replies
  • Best Answer
  • October 7, 2020

It's not actually something that's easily solvable in FME in my opinion

 

You could use an inlinequerier to create all possible permutations then add up the scores and sort and keep the highest. If you have lots of data then python is probably going to be a better option

Capture

 

 

 

jan_van_prooije
Contributor
Forum|alt.badge.img+1
  • jan_van_prooijeContributor
  • Author
  • Contributor
  • 4 replies
  • October 7, 2020

It's not actually something that's easily solvable in FME in my opinion

 

You could use an inlinequerier to create all possible permutations then add up the scores and sort and keep the highest. If you have lots of data then python is probably going to be a better option

Capture

 

 

 

Thanks a lot! The InlineQuerier, didn't know that transformer😅

Community Stats

32,070
Posts
121,782
Replies
39,700
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.