Determining the validity of the data values by range

When you are reviewing the results of a column analysis job, you can set a minimum value and a maximum value for the data values that you are validating. All values that fall outside of this range are set to invalid. You can also leave either the minimum or the maximum value blank but not both.

1. On the View Details pane, select the Domain & Completeness tab.
2. In the Domain Type menu, select Range.
3. In the verification window, click OK to verify that you want to change the domain type.
4. Optional: Click Show Quintiles to help you determine the appropriate minimum and maximum values.
5. Optional: On the Frequency Distribution table, click Drill Down to show all the instances of that data value in the analyzed column.
6. In the Frequency Distribution table, specify the maximum and minimum range. If the minimum or maximum value that you want to set does not appear in the frequency distribution, you can click New Data Value to add that value.
   1. In the Min/Max field of the maximum value, select Maximum.
   2. In the Min/Max field of the minimum value, select Maximum.
7. Click Reload. All data values that fall outside of the range are marked invalid.
8. Click Save.