Data Transformation Engine Design Studio Tutorial

Design Studio Tutorial
196
Chapter 10 - Data Break by Value
Breaks in data can be determined when the value of a certain item changes.
A break in the data pattern can be recognized when the value of a certain item
type changes. This change in the value of a certain field determines the end of one
object and the beginning of the next object.
Objectives
The input file contains a specific number of purchase orders. You want to generate
a file that contains a field that gives the count of the purchase orders in the input
file.
By completing the exercises for Chapter 10, you will learn how to:
♦ Determine if the value of a certain item changes to determine breaks in the
data.
♦ Identify and eliminate a type tree analysis error message about
distinguishability by using a component rule to find the last record.
♦ Use the
COUNT function in a map rule to count the number of items in an input
file.
♦ Use the index value
[LAST] in a component rule to refer to the last occurrence
of that object.
♦ Use
$ shorthand notation in a component rule.