Installation and Configuration Guide

10.1
- 10.1 HotFix 1

Back Next

Row Rules

A row rule analyzes the records in a cluster and selects rows of records that match the rule. You can use multiple rules to filter the records to get a single row of preferred record.

If the row rules return more than one record, the consolidation process uses the user-defined default rules to get a single row of preferred record. If you do not define the default rules, the consolidation process uses the system-defined default rules. If the default rules do not identify a single row of record, the consolidation process skips the cluster.

You can configure a name for each rule and set the rule type and execution order. The consolidation process runs the rules based on the execution order until the consolidation process selects a single row of preferred record.

You can use the following row rules:

RANK

MODAL_EXACT

MOST_FILLED

MOST_DATA

MAX_COLUMN

MIN_COLUMN

EQUALS_COLUMN

The following sample lists some row rules:

<RowRules>
   <RowRule name="rowlevel1" rule="MOST_DATA" order="1" />
   <RowRule name="rowlevel3" rule="MOST_FILLED" order="3" />
   <RowRule name="rowLevel2" rule="RANK" order="2">
      <ReferenceColumn columnName="CITY" />
      <Value columnValue="TORONTO" weight="10" />
      <Value columnValue="BANGALORE" weight="90" />
   </RowRule>
   <RowRule name="rowLevel5" rule="MAX_COLUMN" order="5">
      <ReferenceColumn columnValue="AGE" />
   </RowRule>
   <RowRule name="rowLevel4" rule="EQUALS_COLUMN" order="4">
      <ReferenceColumn columnName="AGE">50</ReferenceColumn>
   </RowRule>
   <RowRule name="rowlevel7" rule="MODAL_EXACT" order="7" />
   <RowRule name="rowLevel6" rule="MIN_COLUMN" order="6">
      <ReferenceColumn columnName="AMOUNT" />
   </RowRule>
   <RowRule name="rowLevel8" rule="RANK" order="8">
      <ReferenceColumn columnName="LMT_SOURCE_NAME" />
      <Value columnValue="Salesforce" weight="10" />
      <Value columnValue="ERP" weight="90" />
   </RowRule>
</RowRules>

Creating a Consolidation Rules File

Download Guide

Watch

Comments

Communities