Installation and Configuration Guide

10.1 HotFix 1
- 10.1

Back Next

EQUALS_OTHER_COLUMN

The EQUALS_OTHER_COLUMN rule selects a column value from a row that fulfills the specified condition. The specified condition can be based on another column.

For example, use the City value of a record as the preferred column value if the Department column value of the record is equal to Human Resources.

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

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

The following table lists the preferred record with the preferred column value based on the EQUALS_OTHER_COLUMN rule applied on the City column:

Cluster ID	Employee Name	City	Age	Department	Comment
1	John Smith	Redwood City	31	Sales	Column-level preferred record

Redwood City is the preferred column value because it is part of the row that contains Human Resources as the Department column value.

Use the following format to configure an EQUALS_OTHER_COLUMN rule:

<ColumnRules>   
   <ColumnRule name="<Rule name>" rule="EQUALS_OTHER_COLUMN" columnName="<Primary column name">
      <ReferenceColumn columnName="Reference column name"><Matching value></ReferenceColumn>
   </ColumnRule>   
</ColumnRules>

The format uses the following parameters:

Rule name: Unique name for the rule.
Primary column name: Name of the column based on which you want to configure the rule.
Reference column name: Name of the column in which you want to search for the matching value.
Matching value: Value to search in the secondary column. The consolidation process identifies the record that contains the specified column value and then uses the primary column value from the selected record as the preferred column value.

The following sample EQUALS_OTHER_COLUMN rule indicates to use the City value as the preferred column value if the Department column value is equal to Human Resources:

<ColumnRules>
   <ColumnRule name="OTHEREQ_RULE1" rule="EQUALS_OTHER_COLUMN" columnName="City">
      <ReferenceColumn columnName="Department">Human Resources</ReferenceColumn>
   </ColumnRule>
</ColumnRules>

Rename Saved Search

Table of Contents

Installation and Configuration Guide

Installation and Configuration Guide

EQUALS_OTHER_COLUMN

EQUALS_OTHER_COLUMN