Duplicate Matching
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am trying to see if there are duplicates within the below table based on a condition.
The condition is: If two or more rows have the same "Supplier" but different "Supplier ID" then i would like these rows/records to be flagged. See below example of data input and and output example.
Data Input
Supplier ID | Supplier | Remit Supp |
0000000003 | 1031ADV | 0000000003 |
0000000002 | 1031ADV | 0000000003 |
0000000003 | 1031ADV | 0000000003 |
0000000003 | 1031ADV | 0000000003 |
0000000005 | 1031ADV | 0000000003 |
0000000011 | 22PROPE | 0000000011 |
0000000011 | 22PROPE | 0000000011 |
0000000012 | 22PROPE | 0000000011 |
0000000011 | 22PROPE | 0000000011 |
0000000011 | 22PROPF | 0000000011 |
0000000014 | FILLMOR | 0000000014 |
0000000029 | ACITYDI | 0000000029 |
0000000036 | AMAPPRA | 0000000036 |
0000000038 | AMAPPRA | 0000000036 |
0000000036 | AMAPPRA | 0000000036 |
Data Output of Duplicates
Supplier ID | Supplier | Remit Supp |
0000000002 | 1031ADV | 0000000003 |
0000000005 | 1031ADV | 0000000003 |
0000000012 | 22PROPE | 0000000011 |
0000000038 | AMAPPRA | 0000000036 |
Is this possible to built?
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Data Investigation
- Database Connection
- Datasets
- Fuzzy Match
- Installation
- Interface Tools
- Join
- Location Optimizer
- Optimization
- Predictive Analysis
- Preparation
- Prescriptive Analytics
- Publish
- Python
- Qlik
- R Tool
- Regex
- Reporting
- Run Command
- Salesforce
- Scheduler
- Server
- Settings
- Sharepoint
- Spatial Analysis
- Tableau
- Time Series
- Tips and Tricks
- Transformation
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@MarqueeCrew turned this into a macro called Only Unique: http://www.chaosreignswithin.com/2014/08/only-unique-macro.html
 
The concept isolates the records that are truly unique rather than the default unique tool function which passes through the first unique value.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BrandonB this worked perfectly! thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @BrandonB how can I download this macro?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @sahartz
The CREW Macros are developed by a third party and can be accessed through the link above. Because they were not created internally, there is a small subset that are officially Alteryx Supported and the rest are Alteryx Community supported: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740
![](/skins/images/9AF25434D4F136B28264A96CA92E8A93/responsive_peak/images/icon_anonymous_message.png)