Data Transformation Engine Design Studio Tutorial

Chapter 8 - Using the CHOOSE Function Raffle.mtt Type Tree
Design Studio Tutorial
174
The syntax of the
CHOOSE function is:
CHOOSE (
from_these_objects , pick_the_nth_one )
The
CHOOSE function has two arguments and selects an object from a series.
♦ The first argument is the series of prize objects to choose from:
from_these_objects
♦ The second argument is the index number of the object chosen:
pick_the_nth_one
Raffle.mtt Type Tree
Open the Raffle.mtt type tree and define the group types to represent the three
files: the prize file, the winner file, and the output file.
The item types that represent the fields have been created for you.