Compare rows

[krystan]

Hi

Is it possible to vertically compare data rows

for example


row 1: 1,2,3,4,5,6
row 2: 1.2.4,3,5,6

In a vertical comparison we would highlight the 3rd and 4th value as being different to the previous rows, I'd like this to be done for all rows in a set (potentially thousands of rows)

Is this possible with the current features?

Krystan

[Aaron]

Hello,

In these files, is the character position the important factor in determining what a column is, or a delimiter character (. or ,)?

If the character position is the determining factor:
For the Text Compare, you can define a new Text format in the Tools menu -> File Formats, new Text Format, and make the mask match your files. Then in the Misc tab, enable Column-based data.

If you are using a delimiter character:
Using the Data Compare session type, you can define a delimiter which will separate your data into columns. This would be a new Data format. You would also need to define a Key column to determine which rows should align with which rows (usually an IDNumber column, or the combination of two columns like FirstName and LastName).