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

Find Duplicate Values in a column and compare values in another column

Aaron_Bowen
7 - Meteor

Hello, 

 

I have a workflow that is combining multiple data streams. Duplicate values are found in one of the columns: 

Aaron_Bowen_1-1683301323122.png

 

In another column there are Network IDs that are different:

Aaron_Bowen_2-1683301392545.png

 

I need to keep the row that contains the most Network IDs while eliminating all of the other rows. Not sure how to best accomplish this. Can someone please help? The end product should be a single row for Row Number "AZ-000867" with the Network IDs "AZN003, AZN007, AZN002."

 

Thanks, 

 

AB

 

2 REPLIES 2
Clifford_Coon
11 - Bolide

Hi @Aaron_Bowen ,

 

Here is one way:

 

Count the number of Commas in the ID field

Sort by Count (decending)

Sample the first of each row

Annotation 2023-05-05 124029.jpg

Aaron_Bowen
7 - Meteor

Thank you so much! Worked like a charm. :) 

Labels
Top Solution Authors