This combines records which share the same value in a text column, aggregating the values of similar rows. A new column labelled ‘Count’ is added in the first column position with the number of original rows that were combined.
Syntax:
CombineSimilar, TextColumnCaption, aggregation
CombineSimilarByIndex, TextColumnIndex, aggregation
Parameters:
TextColumnCaption – enter the exact text of the row label or text column to be combined.
TextColumnIndex – the zero-based index of the text column to be combined, or ‘-1’ for the row label.
aggregation – the aggregation to be used when combining rows {Average, Sum, Maximum, Minimum, First, Last, Median}
Examples:
CombineSimiliar,Sector,Average
CombineSimiliarByIndex,0,Average
These examples look for unique values in the text column ‘Sector’ ( or the first text column in the second example), and counts the number of records with each unique value, then averages each of the data columns.
CombineSimilar,RowLabel,Sum
CombineSimilarByIndex,-1,Sum
These examples demonstrate checking for unique values in the row label. All rows which have identical row labels will have their values averaged and a new data column will be inserted which contains the count of records matched the row label.
|
