Fixing Errors in an Exception Task
You can update the records in a correct exceptions task and in a review exceptions task. Examine the records in the task, and update the fields that contain the data quality errors.
You edit the records in the Data Editing tab.
1. Open the exception task.
Verify that the task displays the Data Editing tab.
2. Click Edit.
3. Examine the records. Select a data field that contains an error that you can fix.
Move the pointer over the field to see the type of data error that the field contains.
4. Enter the correct value in the data field.
The field appearance changes. The Analyst tool clears the background color from the field and adds a green check mark in the top right corner.
5. Save the task.
Repeat the steps for the other records in the task.
Note: The Human task properties might indicate that every error cell must contain a value. In this case, you cannot complete the task until you enter a value in every error cell.
Validation Errors in Exception Tasks
The Analyst tool displays a validation error if you try to enter a data value that is not valid for the column that stores it. You cannot enter a string data value to a numeric column. You cannot enter a data value to a column if the value is longer than the maximum character length in the column.
The Analyst tool can also display validation errors during find and replace operations. You cannot replace a value with another value if the replacement value is not valid in the destination column.
Example: City Names in India
You are a data steward in a multinational organization, and you work on an exception task that identifies older city names in India. You use a list of current and older city names to update the records in the task. For each city, you use the Replace All option to update the name. You use the default option to replace the values in all string data.
One of the columns that contains a city name specifies a maximum character length that cannot accommodate the current name. For example, the name Thiruvananthapuram replaces the name Trivandrum in the Indian state of Kerala. When the Analyst tool tries to update the name in the column, the operation fails and the Analyst tool displays an error.