Editing a Column Definition

Previous Up Next

The Column Handling dialog allows you to set options for each comparison column.  A subset of this dialog is used to set default handling for all columns.

Specify the Name to be displayed in the header of the comparison column.  If none is specified, an automatic one may be used.

Mark the Key checkbox to make data in this column control sorting and alignment.  If you have more than one key column, the priority for sorting is granted to the top-most columns in the list.

Mark the Use Default checkbox to use the default column handling as defined for this session.

Pick the appropriate Type for the column:

Detected

Automatically determine the column type based on the data in the files.

Boolean

Column values are either "True" or "False", or numeric.  Zero is equivalent to False and any non-zero value is True.

Date

Column contains date-time values in any common format.  The comparison ignores differences in formatting.

Numeric

Column values are interpreted as real number values.  The comparison ignores differences in formatting.  For example, 0.00 and 0 are considered the same.

Text

Column contains textual data.

Mark the Unimportant checkbox to indicate that this column is not important to the comparison.  (Unimportant differences are colored blue instead of red, or are ignored altogether using the Ignore Unimportant Differences feature.)

Use Date tolerance to allow date-time values in this column to differ by the given amount before being considered an important difference.

Set the Numeric tolerance value to allow numbers to differ by the given amount before being considered an important difference.

The Text important, except for options govern columns that are defined or detected as Text.  Mark the Character case (ABC = abc) checkbox if differences in case (i.e., capitalization) are unimportant.  Mark the Whitespace checkbox to consider differences in whitespace (the number of blanks before, after or between words) unimportant.