Installation and Configuration Guide

10.1
- 10.1 HotFix 1

Back Next

MAX_COLUMN

The MAX_COLUMN rule selects the row that contains the highest value in the specified column. The MAX_COLUMN rule uses case-insensitive lexicographical ordering to find the highest value.

The following table displays a sample cluster and indicates the preferred record for the cluster based on age:

Cluster ID	Employee Name	City	Age	Department	Comment
1	John Smith	San Francisco	31	Sales
1	J Smith	Redwood City	30	Human Resources
1	John Jr Smith	Seattle	32	Support	Row-level preferred record

The MAX_COLUMN rule selects the third row as the preferred record because it contains the highest age.

Use the following format to configure a MAX_COLUMN rule:

<RowRules>   
   <RowRule name="<Rule name>" rule="MAX_COLUMN" order="<Execution order>">
      <ReferenceColumn columnName="<Column name>" />      
   </RowRule>   
</RowRules>

The format uses the following parameters:

Rule name: Unique name for the rule.
Execution order: Optional. Order of execution for the rule. Use an integer value for the order of execution. If you do not specify the execution order, the consolidation process runs the rule based on the sequence of rules listed in the consolidation rules file. If you specify the execution order for a rule, you must specify the execution order for other rules.
Column name: Name of the column based on which you want to configure the rule.

The following sample MAX_COLUMN rule is configured for the AGE column:

<RowRules>   
   <RowRule name="rowLevel5" rule="MAX_COLUMN" order="1">
      <ReferenceColumn columnName="AGE" />
   </RowRule>
</RowRules>

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

MAX_COLUMN

MAX_COLUMN