Manually Mapping Data Fields

ComparePro automatically maps baseline data to test data, using the Automap feature. By default, fields are mapped in the order they appear in the file or table. The Field Pairing window allows you manually match baseline data with test data.

To manually match data fields

1. Select the Pairings tab in the ComparePro window.
2. On the Field Pairing tab, click . The Field Pairing dialog box appears.
3. On the Baseline Fields tab, select the fields to include in the comparison. To select the same fields in the test data, click . This option selects fields in the test data with the same name.

4. Select the Test Fields tab, and select the fields to include in this comparison. To select the same fields in the baseline data, click . This option selects fields in the baseline data with the same name.

   Success

   Tip

   You can switch back and forth between tabs multiple times.

5. After selecting all of the fields to include in this comparison, click the Field Pairings tab. The left side of this tab lists all of the data fields included in the test data. The right side of this tab displays the pairings of baseline data to test data.

   Warning

   Note

   On this tab, Test data fields are mapped to Baseline data fields. The Baseline Fields column does not change. Any changes are displayed in the Test Field column.

   Success

   Tip

   Use the Automap feature to match all of the fields by name, type, size, or sequential order.

6. Select a field in the Available Test Fields, and drag-and-drop this field onto the appropriate field in the Baseline to Test Field Pairs section. The Test Field column is updated to reflect the new field mapping.
7. When you have finished mapping fields, click OK to save your changes and return to the ComparePro Pairings tab.