Data Transformation Engine Map Designer Reference Guide

Chapter 9 - Functional Map Wizard Using a Functional Map to Increment Data

Map Designer Reference Guide

162

The BatchMap executable map maps the entire input of multiple POs to the

output set of Invoices. This map will call the POToInvoice map which maps

each PO. In addition, POToInvoice calls the functional map ItemMap which

maps each item. Shown below is a diagram illustrating how the maps are related:

BatchMap

calls

POToInvoice

calls

ItemMap

BatchMap

POToInvoice

In BatchMap, the map rule on the Invoice(s) output data object references the

map POToInvoice. The input argument of POToInvoice is PO:POBatch. This

ensures that one Invoice will be generated for each PO.

Using a Functional Map to Increment Data

A functional map can only map input or output data that is passed to it as an

argument. Therefore, to generate consecutive line item numbers for multiple

occurrences, use the

INDEX function on objects as an input argument of the

functional map. Each time that data object is called, the index of the current

object will be sent to it.

For example, when ItemMap is called for the first time, the index of the

LineItem will be 1. When ItemMap is called for the second time, the index of the

LineItem will be 2. This number will then be mapped to the field Item#.