Now, let’s see how Fuzzy match works here. Department “Sale” doesn’t match with the Department table, because it is missing an “S” at the end to match with the “Sales”. You can see that the Merge operation only finds the EXACT Matching scenarios.
This process will give you the output below: (result below is after expanding the merge’s column output) Then you can select the second table and choose Department as the joining field To use Merge operation on the “source” query, You can click on the Merge Queries as New option in the Home tab of Power Query Editor window. Merge or Join is simply the act of combining two tables with different structures, but with link/join columns, to access columns from one of the tables in the other one.
If you want to learn more details about what is Merge and the different types of join or merge, read my other blog post here. If you want to learn what is the Merge operation itself and the difference of that with Append, read my blog post here. Now let’s see how this is possible? Fuzzy Mergeįuzzy Merge is a way of joining two tables together, but not on exact matching criteria, but on the similarity threshold. Or another example is “Managmnt” and “Management”.Ī “Department” table which has a list of all departments Īs you can see the list of Department Names are clean in this table, and this is the table that should be used to clean the “source” table. we have department values such as “Sales”, and “Sale”. Notice that the Department field has data quality issues. Sample Datasetįor this example I will be using a sample dataset which has two very simple tables below Ī “source” table which is the data of employees and their departments. In the Options window, under Preview Features, select the checkbox beside “Enable fuzzy merge”Īfter this step, you’ll need to close the Power BI Desktop and open it again.
Enable the Preview FeatureĪt the time of writing this blog post, Fuzzy matching is a preview feature, and you have to enable it in Power BI Desktop -> Files -> Options and Settings -> Options To learn more about Power BI, read Power BI from Rookie to Rock Star. Let’s explore in details how the fuzzy matching works in Power BI. Yay! Have you ever wanted to match two tables together but not on exact matches, but also on a threshold of similarity? if your answer to this question is yes, then this feature is built for you. After a long wait, in the October 2018 release of Power BI Desktop we saw the fuzzy matching feature added finally.
0 kommentar(er)
