| Option |
Description |
| Main Comparison Methods: |
|
| 1. Whole blocks |
This method is applied for comparison of the data not containing unique identifiers, and the Amended worksheet saves the relative order of rows. The differences report displays the changed rows by whole blocks if they are adjacent. |
| 2. Line by line |
This method has two differences from the previous one: 1. it is two-pass and 2. the differences report displays both the original and the changed rows grouped in pairs. |
| 3. Unique identification |
This method is applied for comparison of the data containing a database structure or unique identifiers. The differences report displays both the original and the changed rows grouped in pairs. |
| Comparison methods for two rows: |
|
| 0. Letter-by-letter |
The values of each of the two rows are joined into one string. Then the two strings are compared using the letter-by-letter method. Suppose the first row contains the values of cells A, B, C, D, E, and the second row contains the values of cells A, F, C, D, E. Therefore two strings 'ABCDE' and 'AFCDE' will be compared. It is the slowest, but the most accurate way. |
| 1. Cell-by-cell |
Two rows are compared using the cell-by-cell method. Rows can have some displaced columns (removed and added columns). This method is faster than the letter-by-letter method. |
| 2. Cell-by-cell, for lists #1 |
Use this method to compare lists that do not have any displaced columns (removed and added columns). In this case, the values of the cells are compared consistently. Note: long identical values of cells tend to suggest considering the compared rows similar. This method has the greatest speed. |
| 3. Cell-by-cell, for lists #2 |
This method has only one difference from the previous one - it does not take into account the length of the cell values. |
| Similarity Rate |
Specify the 'Similarity Rate' value for 'Line by Line' or 'Unique identification' comparison methods. The rows are considered 'Changed', if the "similarity" percent is more or equal to the 'Similarity Rate' value. The minimum value is 10 and the maximum is 99. The default value is 65. |
| Compare rows, which have ununique identifiers |
Allows searching for matches between several rows which have the same identifier when the "Unique Identification" method is used. |
