Adding a Table to Table Attribute check to a composite check

The Table to Table Attribute check allows you to compare table attributes to feature attributes. In a composite check, you can compare values in one feature class or table to another feature class or table. For example, you could compare valid height values in a table to height attribute values on a feature class.

Learn more about the Table to Table Attribute check

Steps:
  1. Start ArcMap.
  2. On the main menu, click Customize > Toolbars > Data Reviewer.
  3. Click the Select Data Check drop-down arrow on the Data Reviewer toolbar, click the plus sign (+) next to Advanced, then click Composite Check.

    The Composite Check Properties dialog box appears.

    Composite Check Properties dialog box

  4. If necessary, type a unique name for the check in the Check Title text box.
    NoteNote:

    The check title can be used to describe the conditions you are looking for with the check. This is useful when you have multiple instances of the same check to validate the same feature classes or tables but with different validation parameters.

  5. Click the Feature or Object Class/Subtype drop-down arrow and choose the feature class on which you want to base all the checks in the composite check.

    The feature class or table you choose is used as Feature Class 1 in the checks you create as part of the composite check.

  6. Right-click in the Build a Composite Check list and click Add Check > Table to Table Attribute Check.

    The Table to Table Attribute Check Properties dialog box appears.

    The first feature class and the notes and severity information are populated with values from the Composite Check Properties dialog box.

  7. Click the Feature or Object Class/Subtype drop-down arrow in the Feature or Object Class 2 area and choose the feature class and subtype on which to run the check.
  8. To run the check on the entire feature class and save this setting, check the Always Run on Full Database check box.
  9. To run the check on specific features in a feature class, click SQL to construct an SQL query.
  10. Choose an option for comparing attributes in the Attributes area.

    To compare all attributes

    Choose the Compare All Attributes option and proceed to step 11.

    TipTip:

    If you choose to compare all the attribute values, you can optionally ignore common attributes between the two tables.

    To compare certain attributes by defining error conditions

    Choose the Compare Attributes option and proceed to step 12.

  11. If you have chosen the Compare All Attributes option and want to ignore certain attributes, do the following:
    1. Check the Attributes to Ignore (Feature Level Metadata) check box.

      The Attributes To Ignore dialog box appears.

      Attributes To Ignore dialog box
    2. Check the check boxes next to the names of the attributes you want to ignore when finding spatial relationships.
      TipTip:

      To check or uncheck all the check boxes next to the attribute names, click Select All or Clear All, respectively.

    3. Click OK.

      The Table to Table Attribute Check Properties dialog box appears.

    4. Proceed to step 13.
  12. If you have chosen the Compare Attributes option, do the following:
    1. Click Select Attributes.

      The Compare Attributes dialog box appears. Feature classes 1 and 2 automatically populate the Data Source 1 and Data Source 2 fields.

      Compare Attributes dialog box
    2. Click the Data Source 1 Attribute drop-down arrow and choose a field to use in the comparison.
    3. Click the Data Source 2 Attribute drop-down arrow and choose a field to use in the comparison.
    4. Click the Operator drop-down arrow and choose an operator to use in the comparison.
    5. Click Add.

      The condition is added to the Error Conditions list.

    6. Repeat steps 12b–12e as necessary.
    7. Click OK.

      The Table to Table Attribute Check Properties dialog box appears.

    8. Proceed to step 13.
  13. Click OK.

    The Composite Check Properties dialog box appears.

  14. Click OK.
1/29/2015