Lets Power Query pair up text values that are similar rather than identical, scoring them with Jaccard similarity against a threshold (default 0.80), with options like case-insensitivity. Fuzzy merge relies on it, as does fuzzy grouping in Power Query Online.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Fuzzy matching in context, with comparison tables and the common traps.
Terms in this definition
- VALUES
Returns in DAX the distinct column values, or table rows, still visible after filters are applied, sometimes with an extra blank entry. CALCULATE often takes the result as a table filter.
- Table options
Set only at creation with
OPTIONS, these key-value storage settings can't be altered or dropped afterwards; on Delta tables they also show up among the table properties. - LIKE
Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
- MERGE
A SQL command that compares a source with a target table and, depending on whether rows match, inserts, updates or deletes them. Fabric Warehouse supports it as generally available, and Spark SQL offers MERGE INTO for Delta tables.
- Online management group
Workloads that may talk directly to or from the internet, or that need no virtual network at all, go in this management group. It is a sibling of Corp and Local beneath Landing zones.