Data Transformation Engine Design Studio Tutorial

Chapter 10 - Data Break by Value Control.mtt Type Tree
Design Studio Tutorial
200
The purchase order is decribed by the PO group type. We know that one purchase
PO can be distinguished from the next purchase order PO by the value of the
purchase order number.
Adding a Component Rule for Distinguishability
Add a component rule to bind together, into a single PO, all of the records (group
type Record) that have the same value in the PO# Field. The component rule
defines a PO as all of the consecutive Records that have a PO# matching the
PO# in the previous Record.
The component rule specifies that the PO# of the given record is equal to the
PO# in the previous record of that PO. If it is not, the given record is known to be
part of a different PO.
The component rule is for the Record component of PO.
Tip Type names separated by a colon (:) indicate a component relationship.
In a component rule, the index value
[LAST] refers to the last occurrence of that
object.
The component rule for the Record component of PO is:
PO# Field:Record = PO# Field:Record[LAST]
To enter the component rule for the Record component of PO
1 Open the PO Data group window.
2 Place current focus on the component rule cell for the Record component of
PO.
3 Press the Alt key and drag the PO# item type from the type tree window to
the component rule bar.
4 Enter a colon (:) after PO#.