Find Duplicate records with multiple conditions

[Lalaiah]

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.

[saveeshkumar]

Hi @Lalaiah ,

Please find the flow.

Thanks

[Qiu]

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

Hi,

Attaching sample data for your reference.

[Lalaiah]

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]

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

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

[saveeshkumar]

Hi @Lalaiah,

Please check and confirm.

Thanks.