Skip to content

Latest commit

 

History

History
30 lines (22 loc) · 1.21 KB

File metadata and controls

30 lines (22 loc) · 1.21 KB
title Task 7: Viewing Updates Made using Master Data Manager in Excel | Microsoft Docs
ms.custom
ms.date 03/09/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology data-quality-services
ms.topic conceptual
ms.assetid c2ff4972-cf18-4d5c-98cd-ec78861a63ce
author lrtoyou1223
ms.author lle
manager craigg

Task 7: Viewing Updates Made using Master Data Manager in Excel

In this task, you verify that you see the updated data from MDS in Excel.

  1. Now, switch to the excel window that has Cleansed and Matched Suppliers spreadsheet open.

  2. Click Refresh button on the ribbon.

    Excel - Refresh Button on Master Data Tab

  3. Notice that names show up (California, New York etc...) for the State field along with their codes.

    Excel - Updated State Codes and Names

Next Step

Task 8: Adding a New Value for State Entity in Excel