Forum Discussion
Solved
Fuzzy vlookup in power query
Hi Experts, please help me on this. i have table1 and table 2 in power query in table1, vendor_name in table2, vendor_name, and cateogory I need to create a new field as category in TA...
If you have not already tried it, adding a column in Table 2 with Table.AddFuzzyClusterColumn() may help with your relationship to Table 1. Here is the link to the learn document.learn.microsoft.com - table.addfuzzyclustercolumn()
As a quick example it turned this...
into this...It is not perfect, but it might help.
jgeddes
Super User
Super UserIf you have not already tried it, adding a column in Table 2 with Table.AddFuzzyClusterColumn() may help with your relationship to Table 1. Here is the link to the learn document.learn.microsoft.com - table.addfuzzyclustercolumn()
As a quick example it turned this...
into this...
It is not perfect, but it might help.