SOLVED
Find Duplicate Values in a column and compare values in another column
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Aaron_Bowen
7 - Meteor
05-05-2023
08:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I have a workflow that is combining multiple data streams. Duplicate values are found in one of the columns:
In another column there are Network IDs that are different:
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
Solved! Go to Solution.
Labels:
- Labels:
- Developer Tools
2 REPLIES 2
Clifford_Coon
11 - Bolide
05-05-2023
09:42 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
05-05-2023
01:59 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you so much! Worked like a charm. :)