fuzzy_cluster_column
Cluster similar text values (e.g., 'Acme', 'acme inc') into a single canonical representative by adding a fuzzy match column to your table, solving data inconsistency issues.
Instructions
Power Query Fuzzy Cluster: add a column giving each row the canonical cluster representative of a text column (groups near-identical values, e.g. 'Acme' / 'acme inc' / 'ACME'). Appends Table.AddFuzzyClusterColumn to the table's M query. threshold is the optional 0..1 similarity cut-off.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| column | Yes | the text column to cluster | |
| newColumn | Yes | the new cluster column name | |
| sessionId | Yes | ||
| threshold | No | similarity threshold 0..1 (optional) | |
| partitionName | No | partition name (optional; defaults to the first partition) |