Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
150
Chapter 7 - Using Cross-Referenced
Data
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 cross-reference data from another source and
incorporate it into the output.
By completing the exercises for Chapter 7, you will learn how to:
♦ Create group types to represent records.
♦ Create group types to represent files of records.
♦ Add components to group types.
♦ Define component ranges.
♦ Use the
LOOKUP function to locate an object in a list that is not organized in
any particular order.
♦ Use the
SORTDOWN function to locate an object in a list that is in descending
order.
♦ Use the
SEARCHUP function to locate an object in a list that is in ascending
order.
♦ [Optional] Use the
SORTUP function to locate an object in a list that is in
ascending order.
♦ [Optional] Use the
SEARCHDOWN function to locate an object in a list that is in
descending order.