Pick the row. with max value of another column

[SrinivasanSugumaran]

Good day. can someone help me to achieve on the below output.. I hav a table and I need to pick the row corresponding to the max. value of another column in the same table.

input:

name	subject	percentage
alex	english	60
	maths	70
	science	80
richard	english	55
	history	86
	geography	90

output:

alex	science	80
richard	geography	90

[Emil_Kos · Accepted solution]

Hi @SrinivasanSugumaran,

So first we need to get the data in a proper structure. I have made a name column populated for all the rows. Afterwards, we need to sort the percentages from the highest to lowest and use the sample function to get the desired results:

The desired output:

Please mark it as a solution if this was helpful for you.

Good Luck!

[Qiu · Accepted solution]

@SrinivasanSugumaran 
A solution that a bit different with @Emil_Kos .

[SrinivasanSugumaran]

thanks qiu

[SrinivasanSugumaran]

thanks emil

[Qiu]

@SrinivasanSugumaran 
Thank you for the mark aslo. Have a nice day!

[Cassidy_M]

Wondering if anyone knows how to deal with ties in this scenario. Can you get Alteryx to return multiple rows if there are ties?