Combined Exact and Fuzzy Matching

Question

DataSet A&nbsp;DataSet B&nbsp;HiI have two datasets A &amp; B which I am trying to match on a number of columns (Entityid, EmailSubject, EmailFrom) in order to reconcile or identify differences in another column (Price).&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I need to first create an exact match on the Entityid Column but because there are slight differences in the EmailSubject and EmailFrom columns, I need to create a fuzzy match on the EmailSubject and Email From columns. If this criteria is met, I need to return the price value from dataset B.&nbsp;From creating a merge on the tables I have the queries below - the first which is an exact match or join and the second which is a fuzzy/approximate. However, I do not know how to combine both queries to get what I am looking for.&nbsp;= Table.NestedJoin(#"Changed Type", {"EntityId"}, CMA, {"EntityId"}, "CMA", JoinKind.LeftOuter)&nbsp;= Table.FuzzyNestedJoin(#"Changed Type", {"EmailSubject", "EmailFrom"}, CMA, {"EmailSubject", "EmailFrom"}, "CMA", JoinKind.LeftOuter, [IgnoreCase=true, IgnoreSpace=true, Threshold=.3])&nbsp;Any help would be greatly appreciated.&nbsp;Thanks

brandonh · Answer

Hello,&nbsp;Did you ever figure this problem out? I have a very similar case where I want to exact match to 2 columns and fuzzy to a thrid.&nbsp;&nbsp;It seems like from other posts here:&nbsp;https://community.fabric.microsoft.com/t5/Power-Query/Merging-with-one-exact-match-column-and-one-fuzzy-join-column/m-p/2272884/highlight/true#M67419&nbsp;that we are looking at a no.

Forum Discussion

Combined Exact and Fuzzy Matching

1 Reply

Related content

Tables combine

Data Combining Problem

Combine Column

Dynamic RLS combination

Combining matrix