How to merge with Contains as Condition? Is this Possible?

[BI_Analyticz]

Friends, I have 2 tables like below. I want to join the 2 tables using the Project Name column but the values are not exactly same. If it possible to merge these 2 tables using any CONTAINS or by any means?

If you look at the below tables I have highlighted the same projects. But the name is slightly different in both the tables. A1-Infra Management is same as Infra Management. Is there any possibility to merge these 2 tables since I need the Project ID from the 2nd table. 

Please suggest my best approaches too.

[PhilipTreacy · Accepted solution]

Hi @BI_Analyticz 

Download sample file 

Use Fuzzy Matching in the Power Query Merge.  If you set the Similarity Threshold to 0.5 all 4 rows in your sample tables are matched.

Regards

Phil

[PC2790]

Hello @BI_Analyticz ,

Have you considered using Fuzzy matching?

So there is an option in the merge window that you can check. See if it turns out to be useful for you.

For more infor on fuzzy matching,Refer link