For each unique value of a designated column, this function creates a new page with all the rows that have that column value. This feature will be most useful following one of the normalization metric operations (ChangeValues).
Syntax:MoveColumnValuesToPages, prefix, columnCaption Parameters:prefix – a prefix to be used in conjunction with generated page captions columnCaption – the label of the column to be used Examples:MoveColumnValuesToPages,Sales June 2007,Sales Quartiles June 2007 The column labeled ‘Sales Quartiles June 2007’ is split into pages based on unique values in the column, and each of the new pages is labeled with a prefix of ‘Sales June 2007’ in the page caption. Comments:In general, one would precede this script command by one of the ChangeValues commands to reduce the number of different values in a data column. The foregoing example presumes, for instance, that they had previously converted the data column to Quartiles. By issuing the MoveColumnValuesToPages script, rows with a certain quartile value will be moved to their own pages. The prefixed page caption would be predictable in the script because it would be the prefix plus the value. This predictable page caption can be used with script commands which accept a page caption as a parameter. |
