Start Free Trial

Alteryx Designer Desktop Discussions

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

Simple Keep Filter

Lauritsjust
7 - Meteor

Hi all

I am trying to find a dynamic solution to keep values of Field1 and Field2 based on a condition of it being the highest number in Field 3.

 

Input:

Lauritsjust_0-1643895408436.png

 

Desired output:

Lauritsjust_1-1643895504754.png

 

It is probably just a simple summarize, but I can't seem to find the combination.

 

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @Lauritsjust 

 

You can acheive this using sort tool followed by sample tool.

 

Workflow:

atcodedog05_0-1643895821226.png

 

Hope this helps : )

 

Lauritsjust
7 - Meteor

Thank you, it works perfectly.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Lauritsjust 

Cheers and have a nice day!

Labels
Top Solution Authors