Forum Discussion

ktt777's avatar
ktt777
Helper V
2 years ago
Solved

Define potential duplications

Hi all,

 

i have a list of entries that was manually entered. There are potential duplications in there.

For example : Star Pte Ltd , Star Pte. Ltd, Stars Pte Ltd

 

Any way to define the list of the potential duplications ?

 

Thanks,

Need Help

3 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    Hi ktt777 -in power query editor you can check the fuzzy matching technique. This approach helps to find similarities between strings that are not exact matches but likely refer to the same entity.

    In your case, where variations in company names might exist due to abbreviations, punctuation, or slight differences. 

     

    Hope it helps

     

    Did I answer your question? Mark my post as a solution! This will help others on the forum!
    Appreciate your Kudos!!

  • ktt777's avatar
    ktt777
    Helper V
    2 years ago

    Thank you. Fuzzy matching usually needs 2 columns to match. What if i only have the original data with name variation without the standard data to compare

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi ktt777 ,

    Based on the description, try to create a new column for standardization.

    Standard = LOWER(TRIM(SUBSTITUTE([Name], ".", "")))

    You can also viewing the following documents to learn more information.

    TRIM function (DAX) - DAX | Microsoft Learn

    SUBSTITUTE function (DAX) - DAX | Microsoft Learn

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.