PL-300 · Question #432
You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns: - Customer_Name - Customer ID - Website The Contacts table contains the…
The correct answer is B. Enable fuzzy matching. To merge tables with unsanitized 'Customer Name' data, you should enable fuzzy matching in Power Query.
Question
You use Power BI Desktop to import two tables named Customer and Contacts. The Customer table contains the following columns:
- Customer_Name
- Customer ID
- Website
The Contacts table contains the following columns:
- Contact ID
- Contact Email
- Contact Name
- Customer Name
A web-based contact form is used to fill the Contacts table. The data is not sanitized. You need to create a merge for the Customer and Contacts tables. What should you do?
Options
- ADisable fuzzy matching.
- BEnable fuzzy matching.
- CSet Join Kind to Left Outer.
How the community answered
(18 responses)- A17% (3)
- B72% (13)
- C11% (2)
Why each option
To merge tables with unsanitized 'Customer Name' data, you should enable fuzzy matching in Power Query.
Disabling fuzzy matching would require exact matches between the 'Customer Name' columns, which would likely result in many unmatched records due to the unsanitized data.
Enabling fuzzy matching in Power Query allows the merge operation to match rows based on approximate text matching, which is essential when joining columns like 'Customer Name' that might have inconsistencies due to unsanitized input, such as typos or variations in spacing or casing.
Setting the Join Kind to Left Outer defines how rows from the second table are included in the result, but it does not address the fundamental issue of matching inconsistent text data between the join columns themselves.
Concept tested: Power Query fuzzy matching for data cleansing
Source: https://learn.microsoft.com/en-us/power-query/merge-queries-fuzzy-match
Community Discussion
No community discussion yet for this question.