Home
CombineDuplicates
This function combines (aggregates) records which are identical in the row label and all text columns. 

Syntax:

CombineDuplicates, aggeregation

Parameters:

aggregation – which data aggregation to use for rows being combined (Average, Sum, Maximum, Minimum, First, Last, Median)

Examples:

CombineDuplicates,Average

This example looks for rows which are identical in their row label and all their text columns.  When it finds a set of records that match, then their data columns will be average.

Comments:

One useful thing to do before this function would be to invoke the function DeleteTextColumn to remove unimportant row properties prior to CombineDuplicates. This would consolidate records that are the same in areas where it is considered important.
 
< Prev   Next >

Reference