Data Transformation Engine Design Studio Tutorial

Chapter 10 - Data Break by Value Control.mtt Type Tree
Design Studio Tutorial
202
Using Shorthand Notation in a Component Rule
For the Record component rule, you can also use shorthand notation.
To use shorthand notation
1 Substitute $ for the Record object name in the component rule.
Analyze and save the type tree.
Data Handling
The first record is processed and the component rule is validated as true or false.
Note The index value [LAST] is interpreted as [1] when no previous occurrences exist.
In the ctrl.txt input file:
12345 500 dress 065.99
12345 1000 pants 032.50
12345 300 suit 200.70
14478 275 pants 032.50
14478 500 suit 200.70
The first Record in the PO file, the component rule is interpreted as:
Is PO# Field:Record[1] = PO# Field:Record[1]?
Is PO# Field:Record[1] = PO# Field:Record[LAST]?
Is 12345 = 12345? Yes