Developer Transformation Guide

10.4.1
- 10.5.2
- 10.5
- 10.4.0

Back Next

CONSOL_MOSTFILLED

Identifies the row that contains the highest number of non-blank fields.

You must use this function in conjunction with the

CONSOL_GETROWFIELD

function. The

CONSOL_GETROWFIELD

returns the values from the row that the

CONSOL_MOSTFILLED

function identifies.

Syntax

CONSOL_MOSTFILLED(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 contains the highest number of non-blank fields, FALSE for all other rows.

Example

The following expression uses the

CONSOL_MOSTFILLED

function to find the row that contains the most characters:

IF (CONSOL_MOSTFILLED(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_MOSTFILLED

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

Developer Transformation Guide

Developer Transformation Guide

CONSOL_MOSTFILLED

CONSOL_MOSTFILLED

Syntax

Return Value

Example