Choose records from a dataset with Maximum value in a column

harish_alt

I have the below dataset:

Student Name	Subject	Marks
A	Mathematics	100
A	Physics	80
A	Computers	50
B	Mathematics	80
B	Computers	80
B	Physics	70

From the above dataset, I need to choose only one record for each student with their highest marks irrespective of the subject. If a student gets same marks in multiple subjects then any ONE of the records should be taken. And in final output, there should be only ONE record for each student with Student Name, Subject and Marks as shown below.

Output:

Student Name	Subject	Marks
A	Mathematics	100
B	Mathematics	80

Please help me in this. Thanks in advance.

Emil_Kos

Hi,

I have prepared a workflow for you. The second solution don't have subject name but it should work as well. 

The sample tool is sorting the data first and I am not 100% sure how it works so please test this for bigger data set. I think it should work as the data was presorted but I recommend testing it out. 

Sample.yxmd