January 1, 2022
I have a database of vendor master.. I am using fuzzy logic to get the duplicate vendors based on vendor names..
The output that i have is like below :
Vendor Name | Duplicate Vendor Name
A | AA
AA | A
Since i am doing fuzzy logic in the same table (Based on vendor name column), i would get 2 rows as above.
I want to keep only only combination of duplicate ie. either A | AA or AA | A, as both would mean the same thing in this context.
I tried various ways of trying to map this combination as a unique value and trying to remove duplicate, but i couldn't assign a unique value.
Any help is much appreciated !