Transformation Guide

Back Next

CONSOL_GETROWFIELD

Reads the row identified by a row-based consolidation function and returns the value for the port you specify. You use a numeric argument to specify a port.

You must use the

CONSOL_GETROWFIELD

function in conjunction with one of the following row-based consolidation functions:

CONSOL_MODALEXACT

CONSOL_MOSTDATA

CONSOL_MOSTFILLED

For each input port in a row-based consolidation function, you must use one instance of the

CONSOL_GETROWFIELD

function .

Syntax

CONSOL_GETROWFIELD(value)

The following table describes the arguments for this command:

Argument	Required/Optional	Description
value	Required	Number that indicates an input port in the row-based consolidation function. Use "0" to specify the leftmost port in the function. Use subsequent numbers to indicate other ports.

Return Value

The value of the port you specify. The function reads this value from a row identified by a row-based consolidation function.

Example

The following expression uses the

CONSOL_GETROWFIELD

function in conjunction with the

CONSOL_MOSTDATA

function:

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

Transformation Guide

Transformation Guide

CONSOL_GETROWFIELD

CONSOL_GETROWFIELD

Syntax

Return Value

Example