Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference CHOOSE

Functions and Expressions Reference Guide

CHOOSE

The CHOOSE function returns the object within a series whose position in the

series corresponds to a specified number.

Syntax

CHOOSE (series-object-name , single-integer-expression)

Meaning

CHOOSE (from_these_objects , pick_the_nth_one)

Returns

This function returns a single-object

Produces a single-object whose index within the from_these_objects series

matches the number specified by pick_the_nth_one. If that member of the

series does not exist,

CHOOSE returns NONE.

Examples

CHOOSE ( Row:DBSelect , 2 ) returns the second Row.

CHOOSE ( Set:Claim , INDEX ( Row:Header ) ) returns the Set within

Claim that corresponds to the index of the Row of Header.

Uses

Use

CHOOSE to use a variable value to specify the index for a particular object

from a series.

Related Function

LOOKUP