Alteryx Designer Desktop Discussions

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

Getting MAX values with Unique ID

debarpanban93
7 - Meteor

debarpanban93_0-1630648943601.png

I want to get the max value per unique ID in my output. Can anyone help?

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @debarpanban93 

 

Use summarize tool groupby on ID and max of value.

 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

debarpanban93
7 - Meteor

Thanks, this worked

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @debarpanban93 

Cheers and have a nice day!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels