Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Duplicate Matching

mustufa2019
8 - Asteroid

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 IDSupplierRemit Supp
00000000031031ADV0000000003
00000000021031ADV0000000003
00000000031031ADV0000000003
00000000031031ADV0000000003
00000000051031ADV0000000003
000000001122PROPE0000000011
000000001122PROPE0000000011
000000001222PROPE0000000011
000000001122PROPE0000000011
000000001122PROPF0000000011
0000000014FILLMOR0000000014
0000000029ACITYDI0000000029
0000000036AMAPPRA0000000036
0000000038AMAPPRA0000000036
0000000036AMAPPRA0000000036

 

Data Output of Duplicates

Supplier IDSupplierRemit Supp
00000000021031ADV0000000003
00000000051031ADV0000000003
000000001222PROPE0000000011
0000000038AMAPPRA0000000036

 

Is this possible to built?

5 REPLIES 5
BrandonB
Alteryx
Alteryx

@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. 

 

unique.png

BrandonB
Alteryx
Alteryx

I actually ended up taking a slightly different approach for this one due to some nuances in your question. Image of workflow is below and workflow is attached!

 

 

duplicates.png

mustufa2019
8 - Asteroid

@BrandonB this worked perfectly! thank you!

sahartz
8 - Asteroid

Hi @BrandonB how can I download this macro?

 

BrandonB
Alteryx
Alteryx

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 

Labels