i have a dataset where i need to get the max from each group, is there a tool that can help me do this? input keycolumn1column21red32red43green74green85blue66blue2 desired output: keycolumn1column22red43green85blue6

Alteryx Academy
MyAlteryx
Knowledge
Help Docs

Home
Participate
Discussions
Alteryx One

Filter to get max value from each group?

i have a dataset where i need to get the max from each group, is there a tool that can help me do this?

input

key	column1	column2
1	red	3
2	red	4
3	green	7
4	green	8
5	blue	6
6	blue	2

desired output:

key	column1	column2
2	red	4
3	green	8
5	blue	6

Data Investigation

Accepted answers

marcusblackhill

Gotcha, see if that attached example helps

EXAMPLE.yxmd

All comments

marcusblackhill

Hey @matthew_swanson !

You can do it with summarize tool, groupby the column 1 and select column 2 to get the max.

Hope that helps!

matthew_swanson

@marcusmontenegroAlmost. ive managed to get the summarize tool to return the max value for each group, but i cant figure out how to make it return the key for that row.. the value itself is only going to be helpful if i know which row it came from

Quick Links

Unanswered
Community Events
Groups

This months top contributors

LanisC 335

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177