Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Choosing duplicate with highest count

olehr
8 - Asteroid

Hi there,

 

I have a date set with duplicates, but the attached data differs:

Highest count.PNG

 

So what I want is to choose the duplicate area-code that has the highest count.  Does anyone have a suggestion ? 🙂

 

Kind regards

 

Henrik

2 REPLIES 2
jdunkerley79
ACE Emeritus
ACE Emeritus

There are a few ways to do this.

clipboard_image_0.png

The easiest I think is to sort by Area (asc) and Count (desc) and then use a sample tool grouped by area to pick first 1 of each area.

 

Quick sample attached

olehr
8 - Asteroid

Thanks. 

 

The solution was simpler than I thought 🙂

Labels
Top Solution Authors