Merges pages with similar page captions by concatenating the rows together. It creates a new text column 'From' that contains the text of the original page captions.

Syntax:

ConcatenatePagesWith, caption, operator 

Parameters:

caption - The string to search for.

operator – the test operator to use { ExactMatch, Contains, StartsWith, EndsWith }

Examples:

ConcatenatePagesWith,Metrics,StartsWith 

This example merges all pages whose page captions begin with the text 'Metrics', such as 'MetricsNew' and 'MetricsOld'. The resulting page will contain all rows from the source pages, plus a new text column titled 'From' that contains 'MetricsNew' or 'MetricsOld' depending on which page it originated from.

Comments:

Note that the columns are simply stacked one over the other, and there is no attempt to align the column labels between the pages as the operation proceeds.

Change history:

v3.1 - new command, replaces ConcatenatePagesBeginningWith,caption