This Analytics Edge wizard is used to combine two sets of data, merging the values from a worksheet or previously named table.
It is generally used with two similar data sets, totalling the numbers, retaining the most recent date, and even preserving a list of reference values.
Combine with Table – select a worksheet or a 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 combine 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).
Add new rows – automatically add rows that are only in the referenced table.
Add new columns – automatically add columns that are only in the referenced table.
Handling Duplicates – where both tables have matching values in the key columns, the remaining columns are combined using the selected options for text, number and date columns. The text option ‘All (list)’ will produce a comma-separated list of values in each cell.
Blog article: Using the Combine Function
Updated for v10.