Forum Discussion

MichaelHutchens's avatar
MichaelHutchens
Helper V
1 year ago
Solved

Column to show string groupings

Hi everyone, I'm hoping someone might be able to help. I'm looking to create a column that shows groupings of similarly-named strings.   The column I need should show unique numbers. These grouping...
Need Help
  • v-echaithra's avatar
    v-echaithra
    1 year ago

    Hi MichaelHutchens ,

    Create a copy of the table by duplicating the table in Power query.

     

    Perform Fuzzy Merge - Self-Join

     

    • Go to Files table.
    • Home > Merge Queries > Merge Queries as New
    • Primary table: Table
    • Secondary table: Duplicated Table
    • Join on File Name using Fuzzy Matching:
    • Check Use fuzzy matching
    • Click Fuzzy matching options:
    • Similarity threshold = tweak as needed
    • check ignore case
    • Max matches: blank

     

    In the merged table, remove duplicates so each pair appears only once by using Table.Distinct

     

    Create a group ID table using DAX to assign a group ID to every file participating in a fuzzy match. You can then join it back to your original file list, and if any file name is not present in the Grouping table, assign that group to 0.

    If this post helps, please give us Kudos and consider marking it Accept as solution to assist other members in finding it more easily.

    Regards,
    Chaithra

MichaelHutchens's avatar
MichaelHutchens
Helper V
1 year ago

Thanks for that rajendraongole1 , very useful. I've amended my original post to remove the DAX requirement. I'll take what solutions I can get.

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi MichaelHutchens ,

May I ask if you have gotten this issue resolved?

 

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

 

Regards,
Chaithra.