Transformation Guide

Back Next

CONSOL_MODALEXACT

Identifies the row with the highest count of the most frequent 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."

You must use this function in conjunction with the

CONSOL_GETROWFIELD

function. The

CONSOL_GETROWFIELD

returns the values from the row that the

CONSOL_MODALEXACT

function identifies.

Syntax

CONSOL_MODALEXACT(string1, [string2, ..., stringN,]
 group by)

The following table describes the arguments for this command:

Argument	Required/Optional	Description
string	Required	Input port name.
group by	Required	Name of the input port that contains the group identifier.

Return Value

TRUE for the row that scores the highest count of the most frequent fields, FALSE for all other rows.

Example

The following expression uses the

CONSOL_MODALEXACT

function to find the row that contains the highest count of the most frequent fields:

IF (CONSOL_MODALEXACT(First_Name,Last_Name,GroupKey,GroupKey))
THEN
First_Name1 := CONSOL_GETROWFIELD(0)
Last_Name1 := CONSOL_GETROWFIELD(1)
GroupKey1 := CONSOL_GETROWFIELD(2)
ELSE
First_Name1 := First_Name
Last_Name1 := Last_Name
GroupKey1 := GroupKey
ENDIF

In this expression, the

CONSOL_MODALEXACT

function analyzes rows in a record group and identifies a single row. The

CONSOL_GETROWFIELD

functions use consecutive numbers to read the port values for that row and write the values to the output ports.

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

CONSOL_MODALEXACT

CONSOL_MODALEXACT

Syntax

Return Value

Example