| title | Match Similar Data | ||
|---|---|---|---|
| description | Match Similar Data (MDS Add-in for Excel) | ||
| author | CordeliaGrey | ||
| ms.author | jiwang6 | ||
| ms.date | 03/01/2017 | ||
| ms.service | sql | ||
| ms.subservice | master-data-services | ||
| ms.topic | how-to | ||
| ms.custom |
|
[!INCLUDE SQL Server Windows Only - ASDBMI]
[!INCLUDE support-notice]
In the [!INCLUDEssMDSshort] [!INCLUDEssMDSXLS], use Data Quality Services (DQS) functionality to find similarities in your data.
To perform this procedure, you can:
-
Use the default Data Quality Services knowledge base, or
-
Create your own custom DQS knowledge base and matching policy. For more information, see Create a Matching Policy.
-
You must have a worksheet that contains MDS-managed data. For more information, see Export Data to Excel from Master Data Services.
-
Optional. You can combine other data with the MDS-managed data before checking for similarities. For more information, see Combine Data (MDS Add-in for Excel).
-
From the worksheet that contains MDS-managed data, in the Data Quality group, click Match Data.
-
In the Match Data dialog box, from the DQS Knowledge Base list, select DQS Data (default).
-
For each column that contains data you want to match, add a row in the dialog box. For information about the fields in this dialog box, see How to Set Matching Rule Parameters.
-
When the total of all weight values equals 100 percent, click OK.
-
From the worksheet that contains MDS-managed data, in the Data Quality group, click Match Data.
-
From the DQS Knowledge Base list, select the name of your custom knowledge base.
-
For each column in the worksheet, select a DQS domain.
-
When all DQS domains are mapped to columns in the worksheet, click OK.
- View additional information to determine which data is similar. For more information, see Data Quality Matching Columns (MDS Add-in for Excel).
Data Quality Matching in the MDS Add-in for Excel
Data Matching