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. |