Developer Transformation Guide

10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5

Back Next

CONSOL_SHORTEST

Analyzes a port in the record group and returns the value with the lowest character count.

Syntax

CONSOL_SHORTEST(string, 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

The port value with the lowest character count.

If the lowest character count is shared by two or more values, the strategy returns the first qualifying value.

Example

The following expression uses the

CONSOL_SHORTEST

function to analyze the FirstName input port and find the value with the lowest character count:

FirstName1:= CONSOL_SHORTEST(FirstName, GroupKey)

In this expression, the

CONSOL_SHORTEST

function uses the GroupKey port to identify a record group. Within that record group, the function analyzes the FirstName port and returns the shortest value. The expression writes this value to the FirstName1 output port.

Rename Saved Search

Table of Contents

Developer Transformation Guide

Developer Transformation Guide

CONSOL_SHORTEST

CONSOL_SHORTEST

Syntax

Return Value

Example