Data Transformation Engine Design Studio Tutorial
Chapter 6 - Using the OR Function with a Lookup File Creating the Preferred Type Tree
Design Studio Tutorial
136
2 For the Date format select YYMMDD.
3 Click OK.
Defining the Customer Group Type
The Customer group type requires the definition of components and changes to
properties in the Properties window.
The Customer group type contains the records.
♦ The item types that represent the records must be defined as components of
the Customer group type.
Each record generated as an output of this map should appear on a separate line.
♦ To generate one record per line, records must be terminated with a <NL>.
Each field in the record is delimited with forward and backward slashes /\.
♦ The Component Syntax must be Delimited.
♦ The Delimiter > Value must be defined with the literal delimiters.
The explicit format relies on syntax to separate components. Each component of
the record can be identified by the /\
delimiter in the data.
♦ The Customer group type must be defined with Format = Explicit.
Note To access help on any type property, put focus on that property in the Properties
window and press F1.
To define the components of the Customer type
1 Double-click the Customer type in the type tree window.
The Customer group window appears.