Developer Transformation Guide

10.5.2
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2 HotFix 1
- 10.2.2 Service Pack 1
- 10.2.2
- 10.2.1

Back Next

CONSOL_MOSTDATA

Identifies the row that contains the most characters across all ports

You must use this function in conjunction with the

CONSOL_GETROWFIELD

function. The

CONSOL_GETROWFIELD

returns the values from the row that the

CONSOL_MOSTDATA

function identifies.

Syntax

CONSOL_MOSTDATA(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 most characters across all ports, FALSE for all other rows.

Example

The following expression uses the

CONSOL_MOSTDATA

function to find the row that contains the most characters:

IF (CONSOL_MOSTDATA(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_MOSTDATA

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_MOSTDATA

CONSOL_MOSTDATA

Syntax

Return Value

Example