Preface
Overview
- Data Quality for Microsoft Excel Overview
- Data Quality Service Process
Installation
Data Quality Services for Excel Users
Data Quality Service Example
Data Quality Services for Developers

Data Quality for Microsoft Excel Guide's Apostrophe Test

10.0
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2
- 10.2 HotFix 1
- 10.2
- 10.1.1 HotFix 2
- 10.1.1 HotFix 1
- 10.1.1
- 10.1

Back Next

Using the Data Quality Service

To validate address data, you add the service URL provided by the developer. You can then run the service against the data in your worksheet.

The following figure shows a Service window that contains the inputs and outputs for an address validation service:

The User Service window contains multiple field names with an Excel spreadsheet cell range for each field. The cell ranges have the following syntax: Sheet1!A:A, Sheet1!B:B, Sheet1!C:C.

Populate the input fields with the corresponding range of data in the worksheet. When you run the service, the data quality service analyzes the input data and generates validated addresses.

Data Quality Service Example

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Data Quality for Microsoft Excel Guide's Apostrophe Test

Data Quality for Microsoft Excel Guide's Apostrophe Test

Using the Data Quality Service

Using the Data Quality Service