Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
19 - Altair
19 - Altair

@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