Home arrow Reference arrow CombineDuplicates

CONTENT WARNING

This site refers to our older, server-based product. If you are interested in our new, Excel-based product, please see our main web site at http://www.nextanalytics.com

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.
 

Reference

Installation - Java