The following table displays a sample cluster and indicates the row-level preferred record:

Cluster ID	Employee Name	City	Donation Amount	Department	Comment
1	John Smith	San Francisco	1000	Sales
1	J Smith	Redwood City	800	Human Resources
1	John Jr Smith	Seattle	900	Support	Row-level preferred record

The following table lists the preferred record with the preferred column value based on the MAX_COLUMN rule applied on the Donation Amount column:

Cluster ID	Employee Name	City	Donation Amount	Department	Comment
1	John Jr Smith	Seattle	900	Support	Column-level preferred record

The MAX_COLUMN rule selects 900 as the preferred column value because it is the highest donation amount based on the lexicographical ordering.

Use the following format to configure a MAX_COLUMN rule:

<ColumnRules>   
   <ColumnRule name="<Rule name>" rule="MAX_COLUMN" columnName="<Column name">
   </ColumnRule>   
</ColumnRules>

The format uses the following parameters:

Rule name

Unique name for the rule.

Column name

Name of the column based on which you want to configure the rule.

The following sample MAX_COLUMN rule is based on the Donation Amount column:

<ColumnRules>
   <ColumnRule name="NAME_RULE" rule="MAX_COLUMN" columnName="Donation Amount"></ColumnRule>
</ColumnRules>