Merge Query - Fuzzy Logic - Results should provide results of unmatched results too

[learning2022]

Hi 

I have 2 tables, and want to identify the values that matches the similar (not exactly the same) in these 2 tables. Currently, using merge queries and than applying a fuzzy logic. However, as the name suggest fuzzy logic is not perfect. It is missing to match some of the values that are existing.

Is there a way to get the list of values in both tables (consolidated in one) - that did not match?

Could there be an alternative and easier approach to what I am trying to acheive?

[v-kkf-msft · Accepted solution]

Hi @learning2022 ,

Please select "Full Outer" for the merged join kind.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[miguel]

Hey!

By doing the Merge operation you'll need to define which is effectively your left and right table.

Perhaps what you're after is not really a merge, but rather first doing an append and then doing a "Group by" with the fuzzy matching and the "All rows" operation? That way you'll see a table at the end with all the values that were "Clustered" into a single value and perhaps rows with only 1 table row because they couldn't be matched with anything else.

You can learn more about fuzzy matching from the following links:

How fuzzy matching works in Power Query - Power Query | Microsoft Docs

Grouping or summarizing rows - Power Query | Microsoft Docs

hope this helps!