Compare

This Analytics Edge wizard is used to compare the current table with another, computing the difference between matching rows.
Also: Using the Compare Function

Add a New Value

This option is used to create a new column containing the comparison between a specific column in the current table with the reference table.

Compare This Column – select this column in the current table, to the selected column in the other table/worksheet.

Compare To – select a worksheet or previously named table from the drop down list.  The worksheet must be in the same workbook, and data must start in cell A1 with a header row. If you want to use a table in memory, use Table Name to create the reference.

By Row Number – select this option to compare the tables by row number. This is useful if the tables have no common columns.

By Key Columns – select columns that will be used to align the two tables together. All values from the selected columns must match for a row to match.

Ignore case – when performing the comparison, match rows even if they have differing upper or lower case letters.

Ignore spaces – when performing the comparison, match rows even if they differ because of different spacing (leading, trailing or within the text).

Comparison – Select the operation to use in the comparison.

New Column Name – Enter a caption for the new column to be created.


Replace Existing Values

This option tab replaces the numbers and dates in the table with the calculated comparisons.

Compare to – select a worksheet or previously named table from the drop down list.  The worksheet must be in the same workbook, and data must start in cell A1 with a header row. If you want to use a table in memory, use Table Name to create the reference.

By Row Number – select this option to compare the tables by row number. This is useful if the tables have no common columns.

By Key Columns – select columns that will be used to align the two tables together. All values from all selected columns must match for a row to match.

Ignore case – when performing the comparison, match rows even if they have differing upper or lower case letters.

Ignore spaces – when performing the comparison, match rows even if they differ because of different spacing (leading, trailing or within the text).

Comparison – where both tables have matching values in the key columns, compare the values of the remaining number and date columns using the selected options. No Change can be selected if you only want to compare the number or date columns.

Updated for v8.2.