Data Transformation Engine Design Studio Tutorial

Chapter 19 - Incrementing Output Data Using the Index Value [LAST]
Design Studio Tutorial
289
When the first purchase order is created, the count of PO is 0, so 1 is added to 0
to make it 1. When the second purchase order is created, the count of PO is 1, so
1 is added to make it 2, and so on.
The map rule uses the
CHOOSE function for details, the INDEX function for
headers, and the
COUNT function for the purchase orders.
Using the Index Value [LAST]
Another way to increment data is to take the index of the last IndexOfPO in the
output, and add 1.
When the first purchase order is created, there is no IndexOfPO item in the
output yet, so the index of the last one is 0. Add 1 to make it 1.
Summary
Output objects can be incremented by counting, using the index value LAST, or by
using the
INDEX function.