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.
Solved! Go to Solution.
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.
thanks Emil_Kos!
I am looking for the first solution.