Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
171
Chapter 8 - Using the CHOOSE
Function
This chapter explains how to decide which function to use when cross-referencing
data, and how to use that function. A map example using each of these functions
is provided.
Objectives
This chapter defines how to locate an object in a certain position in a series.
By completing the exercises for Chapter 8, you will learn how to:
♦ Use the CHOOSE function to locate an object in a certain position in a series.
Files Used in this Chapter
You will be working in the c:\mercator\tutorial\MyFolder\Ch08 folder.
Files Provided for Chapter 8
The following table describes the files provided for this chapter. Use the files
provided in Ch08.zip.
Icon File type Name Description
Text file prizes.txt Input data file containing a list
of the prizes for each place.
Text file winners.txt Input data file containing the
list of winners in order based
on the prize won.
Type tree Raffle.mtt Type tree describing the winner
data (input), the prize data
(input) and the congratulation
data (output).