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.

Find Duplicate records with multiple conditions

Lalaiah
8 - Asteroid

Hi,

 

Can you some one please help me with find duplicate records with multiple conditions. if any of the > 2 records match with any condition it should be identify as duplicate. Attached excel file with example's condition.

 

Lalaiah_0-1645590210388.png

 

6 REPLIES 6
saveeshkumar
9 - Comet

Hi @Lalaiah ,

 

Please find the flow.

 

saveeshkumar_0-1645597276034.png

 

Thanks

Qiu
20 - Arcturus
20 - Arcturus

@Lalaiah 
Can you provide the sample input?

All data of different duplicated types are coming together or different input?

It will change the flow

 

Lalaiah
8 - Asteroid

Hi,

 

Attaching sample data for your reference.

 

Lalaiah
8 - Asteroid

Hi Saveesh,

 

Thanks for your quick response and workflow.

In this case, duplicates are capturing only if they are above and below 1 row, but they must be searched as a whole. There may be multiple duplicate lines, so they should be sorted one by one.

ArtApa
Alteryx
Alteryx

Hi @Lalaiah - Not the most elegant workflow, but hope it meets your requirements:

 

ArtApa_0-1645606660366.png

 

Name Duplicate Type
All unique Null
All duplicates 1
Supplier Number 2
Invoice Date 3
Invoice Number 4
Invoice Amount 5

 

 

saveeshkumar
9 - Comet

Hi @Lalaiah,

 

Please check and confirm.

 

Thanks.

Labels