Match

matchThis Analytics Edge wizard is used to keep or remove rows based on whether matching row values exist in another table or worksheet.

It is usually used by taking the result of one analysis (top product sales, most popular links) and filtering a detail report to see what contributed to the ranking.

Match with Table – 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.

Select 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).

Keep matching rows – keep only rows that have matching rows in the reference table.

Remove matching rows – remove rows that have matching rows in the reference table.

Blog article: Using the Match Function