Installation and Configuration Guide

10.1 HotFix 1
- 10.1

Back Next

EQUALS_COLUMN

The EQUALS_COLUMN rule selects the row that contains the matching value in the specified column.

For example, set the matching value to Sales for the Department column.

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

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

The EQUALS_COLUMN rule selects the first row as the preferred record because the Department column contains Sales.

Use the following format to configure a EQUALS_COLUMN rule:

<RowRules>   
   <RowRule name="<Rule name>" rule="EQUALS_COLUMN" order="<Execution order>">
      <ReferenceColumn columnName="<Column name>"><Matching value></ReferenceColumn>      
   </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.
Matching value: Value based on which you want to identify the preferred record. The consolidation process identifies the records that match the specified value.

The following sample EQUALS_COLUMN rule identifies the matching records that contain Sales as the Department column value:

<RowRules>   
   <RowRule name="rowLevel5" rule="EQUALS_COLUMN" order="5">
      <ReferenceColumn columnName="Department">Sales</ReferenceColumn>
   </RowRule>
</RowRules>

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

EQUALS_COLUMN

EQUALS_COLUMN