Data Quality Matching Columns (MDS Add-in for Excel)
Applies to: 
SQL Server - Windows only
Azure SQL Managed Instance
In the Master Data Services Add-in for Excel, after you match data, in the Data Quality group on the ribbon, you can click Show Details to display columns that provide matching details.
The following table shows the columns that are displayed when matching data.
| Name | Description |
|---|---|
| CLUSTER_ID | A unique identifier used to group similar records. All rows that are similar have the same CLUSTER_ID. If no CLUSTER_ID is displayed for a row, then no similar records were found. |
| RECORD_ID | A unique identifier used to identify records. Similar to the Code value stored in the MDS repository, it is a value used to identify a record. It is generated automatically each time matching takes place. |
| PIVOT_MARK | An arbitrary record that other records are compared to; it does not have a score value. |
| SCORE | Represents how similar the records in the group are to the pivot record. This score is determined by DQS. If no score is displayed, either the record is the pivot for other records, or no matches were found. |
See Also
Data Quality Matching in the MDS Add-in for Excel
Match Similar Data (MDS Add-in for Excel)
Data Matching
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for