Installation and Configuration Guide

Back Next

MIN_COLUMN

The MIN_COLUMN rule selects the lowest column value. The MIN_COLUMN rule uses case-insensitive lexicographical ordering to find the lowest value.

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

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 following table lists the preferred record with the preferred column value based on the MIN_COLUMN rule applied on the Age column:

Cluster ID	Employee Name	City	Age	Department	Comment
1	John Jr Smith	Seattle	30	Support	Column-level preferred record

The MIN_COLUMN rule selects 30 as the preferred column value because it is the lowest age.

Use the following format to configure a MIN_COLUMN rule:

<ColumnRules>   
   <ColumnRule name="<Rule name>" rule="MIN_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 MIN_COLUMN rule is based on the Age column:

<ColumnRules>
   <Column name="NAME_RULE" rule="MIN_COLUMN" columnName="Age"></ColumnRule>
</ColumnRules>