Configuring a Column Rule for a Group of Columns
You can configure a column rule for a group of columns. The consolidation process identifies the preferred column value for each column based on the rule and updates the corresponding column value in the preferred record that the row rules return.
Use the following format to configure a column rule for a group of columns:
<ColumnRules>
<ColumnGroup name="<Unique name>" rule="<Column rule name>">
<ColumnRule columnName="<Column name 1>" />
<ColumnRule columnName="<Column name 2>" />
...
<ColumnRule columnName="<Column name N>" />
</ColumnGroup>
</ColumnRules>
The format uses the following parameters:
- Unique name
- Unique name for the rule.
- Column rule name
- Name of the column rule that you want to use.
- You can use the following column rules:
- RANK
- MOST_DATA
- MODAL_EXACT
- MAX_COLUMN
- MIN_COLUMN
- FROM_MASTER
- EQUALS_OTHER_COLUMN
- MIN_OTHER_COLUMN
- MAX_OTHER_COLUMN
- Column name 1, 2,...N
- Name of the columns for which you want to configure the rule.
The following sample MAX_COLUMN rule is configured for the NAME and CITY columns:
<ColumnRules>
<ColumnGroup name="COL_GROUP1" rule="RANK">
<ColumnRule columnName="NAME" />
<ColumnRule columnName="CITY" />
</ColumnGroup>
</ColumnRules>
