Combine Data (MDS Add-in for Excel)
Applies to: SQL Server (all supported versions) - Windows only Azure SQL Managed Instance
In the Master Data ServicesAdd-in for Excel, combine data from two worksheets when you want to compare data before publishing. In this procedure, you combine data from a two worksheets into one. Then you can perform further comparisons and determine which data, if any, to publish to the MDS repository.
You must have a worksheet that contains MDS-managed data. For more information, see Export Data to Excel from Master Data Services.
You must have a worksheet that contains data you want to combine with MDS-managed data. This sheet must have a header row.
To combine non-managed data into an MDS-managed sheet
On the sheet that contains MDS-managed data, in the Publish and Validate group, click Combine Data.
In the Combine Data dialog box, next to the Range to combine with MDS data text box, click the icon. The dialog box contracts.
Click the sheet that contains the data you want to combine.
Highlight all cells on the sheet that you want to combine, including the header row.
In the Combine Data dialog box, click the icon. The dialog box expands.
For a column listed for the MDS entity, select a column under Corresponding Column. All MDS columns do not need corresponding columns.
Click Combine. A SOURCE column is displayed, indicating whether the data is from MDS or an external source.
- To find similarities between the MDS-managed and external data, see Match Similar Data (MDS Add-in for Excel).