Reorder Columns (MDS Add-in for Excel)
Applies To: SQL Server 2016
In the Master Data ServicesAdd-in for Excel, you can reorder columns by filtering the list before loading.
When you reorder attributes in the Filter dialog box, the data is loaded into Excel with the new order. However, the next time that you filter the attribute data, the order will revert to the order in the original design. To change the order permanently, an administrator should change the order in the System Administration area of Master Data Manager. For more information, see Change the Order of Attributes.
To perform this procedure:
- You must have permission to access the Explorer functional area.
Open Excel and on the Master Data tab, connect to an MDS repository. For more information, see Connect to an MDS Repository (MDS Add-in for Excel).
In the Master Data Explorer pane, select a model and version. The list of entities is populated.
If the Master Data Explorer pane is not visible, in the Connect and Load group, click Show Explorer.
If the Master Data Explorer pane is disabled, it is because the existing sheet already contains MDS-managed data. To enable the pane, open a new worksheet.
In the Master Data Explorer pane, click an entity.
In the Connect and Load group, click Filter.
In the Filter dialog box, in the Columns section, in the list of attributes, click the attribute you want to move.
To the right of the list, click the Up or Down arrow to move the attribute left and right in the worksheet.
Repeat step 7 for each attribute until the top-to-bottom order represents the left-to-right order you want in the worksheet.
Click Load Data. The sheet is populated with MDS-managed data and the columns are displayed in the order you specified.