Something which you could do is to calculate the total number of points first by adding columns 2 and 3 and then use a Top K Row Filter for the first 3.

Sir, Top k Rank Filter will give us only one column ranking.
I want both column ranking at same time. which gives best outcomes.
In your suggestion-Second column will not be part in desirable output.

@CAMahi
This could be more of a mathematical solution, e.g. like this: Normalize the columns score and wicket, multiply these values. The highest value is the total top.

Hi @CAMahi , I certainly think you will need to provide a definition of â€śbestâ€ť. I would at least imagine youâ€™ll need some kind of weighting to the numbers, and perhaps some kind of â€śentry criteriaâ€ť before somebody can be considered an â€śall rounderâ€ť at all?

Just taking two as an example, which of these would you conclude is the better all rounder and why?

Hello @CAMahi
I guess that as @sabsab suggested, it is a mathematical challenge. You may want also to extend some explanations and definitions as @takbb said.

From my point of view what you have in this challenge is a combinatorial problem. It isnâ€™t a KNIME beginnerâ€™s problem; and you would rather achieve in an easier way with some coding support.

You can convert all the sorted values from the two columns into a tuple list; then you will need to find all 2-tuple combinations with repetitionâ€¦ an inner join will return you the the sorted rank results.

I hope this helps.

BR

P.S. Rank node with grouping attributes would work OK for a simple approach

Best mean to say.
A player should be good at both. Not only he should be batsman or bowler.
As Rank nodes in decending order gives the result only for either batsman or either bowler.

As I found one solution.
And yes I probably thinking that it requires mathematical solution. For e.g.

We can give percentage to runs and wicket column.
Runs / total runs 100
And for wicket/Total wicket100
Nest step
We can add this percentage of wicket and runs.
Next we will apply node in decending order.
This will give you statistically best player.
Choose top 3.

And I Really appreciate your effort to look into this matter and guide me.

Thank You

Here I tried to solve this.
You can check on below link.

Hi CAMahi!
Without getting in deep: What about the good old average: wickets per game, runs per game, etc.? Rankings could then be derived from this, which could be used for overall scoring. Perhaps a weighting would also have to be incorporated.