You can run services and configure service properties in the
Use Service
window.
You can configure the following properties:
Available services
Provides a list of the data quality services that you added to Data Quality for Microsoft Excel.
Put results on new sheet
Create an Excel worksheet for the output of the data quality service. You can configure a default value for this property in the
Settings
window.
Close window when finished
Closes the
Use Service
window when the data quality service finishes processing input data. You can configure a default value for this property in the
Settings
window.
Run
Runs the data quality service.
Undo
Removes the results of the data quality service operation from the Microsoft Excel worksheet.
Column input format
Reads data from input fields using a column orientation, reading from top to bottom.
Row input format
Reads data from input fields using a row orientation, reading from left to right.
Autofill input fields
Fills the input fields using the fields, rows, and columns selected in the Microsoft Excel worksheet. You can fill multiple input fields by selecting cell ranges with more than one column or row, or by selecting multiple areas in the worksheet.
Clear input fields
Resets all input fields.
Column output format
Writes data in output fields using a column orientation, writing from top to bottom.
Row output format
Writes data in output fields using a row orientation, writing from left to right.
Autofill output fields
Fills the output fields using the fields, rows, and columns selected in the Microsoft Excel worksheet. You can fill multiple output fields by selecting cell ranges with more than one column or row, or by selecting multiple areas in the worksheet.