This Analytics Edge wizard is used to compare the current table with another, computing the difference between matching rows.
Also: Using the Compare Function
TAB – Add a New Column
This option is used to create a new column containing the comparison between a specific column in the current table with the reference table.
Comparison Table/Worksheet – 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 Selected 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).
New Column Name – Enter a title for the new column to be created.
Compare This Column – select a column in the current table.
To This Column – select a column in the comparison table to compare to.
Comparison – Select the operation to use in the comparison.
TAB – Replace Existing Values
This option tab replaces the numbers and dates in the table with the calculated comparisons.
Comparison Table/Worksheet – 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 Selected 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 v10.