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
Can you provide the sample input?
All data of different duplicated types are coming together or different input?
It will change the flow
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.
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