Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

The name 'Table.FuzzyNestedJoin' wasn't recognized. Make sure it's spelled correctly

When I try to do a "FuzzyNestedJoin" I get this error in Data Flows: "The name 'Table.FuzzyNestedJoin' wasn't recognized. Make sure it's spelled correctly"   Here is what I am doing.........   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous Could you please help me understand where to add the ("="). Here is the step that is failing.

 

  #"Merged queries" = Table.FuzzyNestedJoin(#"Expanded Exclude", {"Account_Name"}, HPG_Roster, {"Name2"}, "HPG_Roster", JoinKind.LeftOuter, [IgnoreCase = true, IgnoreSpace = true, NumberOfMatches = 1])
 
Here is an example of the full advanced aditor. Notice it doesn't even give me the option to do table.FuzzyNestedJoin. It only allows for table.NestedJoin

 

 
PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi Anonymous 

I don't think a missing = is the issue.  If you are creating the join via the GUI then it enters all the necessary syntax for you including the step name and the = before the actual transformation part.

As the GUI offers you the option to do a fuzzy join yet does not list the fuzzy join functions as available either in the #shared query I gave you, or in the Intellisense lst in your last image, this looks like a bug to me.

Try reporting it in Issues and see what response you get

https://community.powerbi.com/t5/Issues/ct-p/PBI_Comm_Issues

Phil

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.