Please enable JavaScript to view this site.

Beyond Compare

1.While in a Table Compare session, choose Session | Session Settings to open the Session Settings dialog.

2.Click the Format page.
 
Each line in the display represents a comparison column and shows the following information:

Comparison if key, column number and column name

Left file column number and sample data if available

Right file column number and sample data if available

Handling summary of column comparison

To control the alignment of rows

Define as many columns as keys as necessary to uniquely identify each row.  By default, the first column is the only one defined as a key.  To define a column as a key, select the appropriate line, click the Edit button, select the Key checkbox, and click OK.  If multiple keys are defined, precedence follows the order in the comparison.  If no keys are defined, the alignment will use all of the columns to uniquely identify each row.

To control the alignment of columns

By default, the comparison assumes the columns of the files are in the same order.  To change the comparison order of a column in the left file, select the appropriate line under Left file and click the Move Up or Move Down button as necessary.  If you select under Comparison instead, those buttons will change the position of the comparison column itself.  

To prevent a column in the left file from being compared, select the appropriate line under Left file and click the Remove button.  If you select under Comparison instead, this button will prevent its file columns from being compared and delete this comparison column definition.  

To restore a removed column from the left file, select under Left file, click the Insert button, select items in the Insert Columns dialog and click OK.  Click the Tidy button to remove any blank lines from the list.

To control the names of columns

By default, column names are automatically determined from the left or right file.  

To give a column a specific name, select the appropriate line, click the Edit button, change the Name, and click OK.  

To revert all columns to automatic naming, choose Reset Names from the list's right-click menu.  

If left file data is available, you can choose Fill Names Using Left File from the list's right-click menu to force the names to use those found in the left file. Fill Names Using Comparison will force the names to use those that would be automatically determined.

To control how column data is compared

Select the appropriate line and click the Edit button to open the Column Handling dialog.  To change the default Handling settings, click the Edit Default button.