Data Transformation Engine Design Studio Tutorial

Chapter 7 - Using Cross-Referenced Data Using the SORTDOWN Function
Design Studio Tutorial
166
Using the SORTDOWN Function
The SORTDOWN function returns a series containing the values from an input series
in descending order.
The syntax of the
SORTDOWN function is:
SORTDOWN (
item_series_to_sort )
The item_series_to_sort is the record containing the zip code and region.
Creating the SortRegion_Descending Map
♦ Create the SortRegion_Descending executable map in the Customer.mms
map source file.
♦ Copy the RegionLookupFile input card #2 in the RegionReport map to the
SortRegion_Descending map. (Keep the input card name the same:
RegionLookupFile.)