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 Jose	31	Sales
1	J Smith	Redwood City	30	Human Resources	Row-level preferred record
1	John Jr Smith	Seattle		Support

The following table lists the preferred record with the preferred column value for the cluster based on the MOST_DATA rule applied on the Employee Name column:

Cluster ID	Employee Name	City	Age	Department	Comment
1	John Jr Smith	Redwood City	30	Human Resources	Column-level preferred record

John Jr Smith is the preferred column value because it has the highest character count.

Use the following format to configure a MOST_DATA rule:

<ColumnRules>   
   <ColumnRule name="<Rule name>" rule="MOST_DATA" 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 MOST_DATA rule is based on the Employee Name column:

<ColumnRules>
   <ColumnRule name="NAME_RULE" rule="MOST_DATA" columnName="Employee Name"></ColumnRule>
</ColumnRules>