Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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.
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
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