Transformation Guide

Back Next

Row-Based Strategies

A row-based strategy analyzes rows in the record group and selects one row. The Consolidation transformation uses the port values from that row to create a consolidated record. The default strategy is "most data."

Choose one of the following row-based strategies:

Most data: Selects the row with the highest character count. If the highest character count is shared by two or more rows, the strategy returns the last qualifying value.
Most filled: Selects the row with the highest number of non-blank columns. If the highest number of non-blank columns is shared by two or more rows, the strategy returns the last qualifying value.
Modal exact: Selects the row with the highest count of the most frequent non-blank values. For example, consider a row that has three ports that contain the most frequent values in the record group. The count of the most frequent values for that row is "3."; If the highest count of the most frequent non-blank values is shared by two or more rows, the strategy returns the last qualifying value.

Row-Based Strategy Example

The following table displays a sample record group. The last column describes the reasons why specific row-based strategies select different rows in this record group.

Product ID	First Name	Last Name	ZIP Code	Strategy Selection
2106	Bartholomew		28516	The Most Data strategy selects this row because the row contains more characters than the other rows.
2236	Bart	Smith	28579	The Most Filled strategy selects this row because the row has more non-blank columns than the other rows.
2236	<Blank>	Smith	28516	The Modal Exact strategy selects this row because the row contains the highest count of the most frequent values.

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

Row-Based Strategies

Row-Based Strategies

Row-Based Strategy Example