Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Choose records from a dataset with Maximum value in a column

harish_alt
6 - Meteoroid

I have the below dataset:

 

Student NameSubjectMarks
AMathematics100
APhysics80
AComputers50
BMathematics80
BComputers80
BPhysics70

 

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 NameSubjectMarks
AMathematics100
BMathematics80

 

Please help me in this. Thanks in advance.

2 REPLIES 2
Emil_Kos
17 - Castor
17 - Castor

Hi,

 

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

Emil_Kos_1-1620132282602.png

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. 

 

 

harish_alt
6 - Meteoroid

thanks Emil_Kos!

I am looking for the first solution.

Labels