Merging UnEven Names in Power Query

montyfern

New Member
Joined
Oct 12, 2017
Messages
35
ok, thanks to you both. For you sandy666, the worksheet is protected so I can't see the query. What's the password please? I think we're really close. However, I can't view the queries due to protection. But, they're two tables. ?

For the German person, thanks so much! I tried to run your code but get an error "Expression.Error: The name 'Table.Tabelle24" wasn't recognized. Make sure it's spelled correctly."

Thanks you both!
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,406
Expression.Error because your Excel PowerQuery version doesn't support Table.FuzzyNestedJoin() function
 
Last edited:

pinarello

New Member
Joined
Jun 1, 2019
Messages
33
Very strange! That should have been called "Table245". But with me the query ran without problems. But now I have reworked it again and added the optional parameter "NumberOfMatches" for the join and assigned it the value 1.


In the folder I also added a link to the Microsoft documentation.


I hope you can now open the folder and execute the Power Query query without any problems.

Here once more the actual link
 

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,406
Table.Fuzzy* was released in October 2018 and Microsoft still didn't update it for all versions of Excel.
It works for 2019 but not for any previous versions. I am not sure about 365
 

pinarello

New Member
Joined
Jun 1, 2019
Messages
33
I use 365 and it works. By the way, a few years ago I programmed a fuzzy search myself that also takes synonym lists into account.
 

pinarello

New Member
Joined
Jun 1, 2019
Messages
33
If the Power Query of your Excel version does not yet support the table join with the fuzzy logic, then there is a very simple way.


Install the free Power BI Desktop version and create the query there. When you have loaded the query, activate the table view, place your cursor in the table and choose the function "Copy table". Now switch to Excel and import the table using Cntrl+V.


Copy and paste is necessary because the free Power BI Desktop version does not offer the possibility to save the query in a format that Excel can read and Excel is not able to read .pbix files.
 

montyfern

New Member
Joined
Oct 12, 2017
Messages
35
Yup, can't use Fuzzy Join. But @pinarello, I've copied all your info down when my co. updates. Great to know, & thanks for all your help & hard work! @ sandy666, much obliged. I'm not sure if she wants two tables but I can handle that. I too use PBI Desktop & a little Tableau. Will undoubtedly have more BI questions as my knowledge of DAX & PQ grows. Cheers! --montyfern
 

Watch MrExcel Video

Forum statistics

Threads
1,099,576
Messages
5,469,489
Members
406,656
Latest member
Kriscrawford76

This Week's Hot Topics

Top