Share via


Task 2: Mapping Excel Columns to DQS Domains

  1. In the Map page, select Excel File for Data Source.

  2. Click Browse, select Suppliers.xlsx, and click Open.

  3. Select IncomingSuppliers$ for the Worksheet.

  4. Map columns as shown in the following table and screenshot. When creating mappings for the State domain, click Add a column mapping button on the toolbar located just above the list.

    Tip

    You are not using Supplier ID column/domain for cleansing. You will use the Supplier ID domain later in the matching activity.

    Excel column

    DQS Domain

    Supplier Name

    Supplier Name

    ContactEmailAddress

    Contact Email

    Address Line

    Address Line

    City

    City

    State

    State

    Country (Click +(Add a column mapping) toolbar to add a row)

    Country

    Zip Code

    Zip

    Mappings of Excel Columns to Domains

  5. As you have mapped all the individual domains within the Address Validation composite domain, the composite domain automatically participates in the cleansing process. Click View/Select Composite Domains button to see that the Address Validation composite domain is automatically selected, and then click OK.

    View/Select Composite Domains Dialog Box

  6. Click Next to switch to the Cleanse page.

Next Step

Task 3: Cleansing Data against the Suppliers Knowledge Base