Table of Contents

Search

  1. Preface
  2. Installing MDM Big Data Relationship Management
  3. Configuring MDM Big Data Relationship Management
  4. Configuring Security
  5. Setting Up the Environment to Process Streaming Data
  6. Configuring Distributed Search
  7. Packaging and Deploying the RESTful Web Services

Installation and Configuration Guide

Installation and Configuration Guide

MAX_OTHER_COLUMN

MAX_OTHER_COLUMN

The MAX_OTHER_COLUMN rule selects a column value from a record that contains the highest value of the specified column. The MAX_OTHER_COLUMN rule uses case-insensitive lexicographical ordering to find the highest value.
For example, use the City value from a record that contains the highest donation amount.
The following table displays a sample cluster and indicates the rule-level preferred record:
Cluster ID
Employee Name
City
Donation Amount
Department
Comment
1
John Smith
San Francisco
1000
Sales
Row-level preferred record
1
J Smith
Redwood City
900
Human Resources
1
John Jr Smith
Seattle
800
Support
The following table lists the preferred record with the preferred column value based on the MAX_OTHER_COLUMN rule applied on the City column:
Cluster ID
Employee Name
City
Donation Amount
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 the highest donation amount.
Use the following format to configure a MAX_OTHER_COLUMN rule:
<ColumnRules> <ColumnRule name="<Rule name>" rule="MAX_OTHER_COLUMN" columnName="<Primary column name"> <ReferenceColumn columnName="<Reference column name>" /> </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 find the highest value. The consolidation process identifies the record that contains the highest column value and then uses the primary column value from the selected record as the preferred column value.
The following sample MAX_OTHER_COLUMN rule indicates to use the City value from a record that contains the highest donation amount:
<ColumnRules> <ColumnRule name="OTHEREQ_RULE1" rule="MAX_OTHER_COLUMN" columnName="City"> <ReferenceColumn columnName="Donation Amount" /> </ColumnRule> </ColumnRules>


Updated June 27, 2019