Data Transformation Engine Map Designer Reference Guide

Chapter 15 - Managing Invalid Data Using the ISERROR Function
Map Designer Reference Guide
238
In the map rule for BadPO(s), use the
REJECT function. The input argument of
the
REJECT function is a PO from the input. Shown below are the map rules used
on the error report output card.
When you run the map, you may see the message Attempting Restart and then
Restart complete if an input is a UFO (unidentified foreign object). A UFO is a
set of data that does not contain any valid data and cannot be recognized as
belonging to any given type.
After you run the map, the first output created is an invoice, and only the good
PO was mapped to that invoice. For example, the first data object in the invoice is
a count of the POs in the input. Its value is 1, therefore only the good PO was
counted.
Using the ISERROR Function
You may conditionally map data based on whether or not a certain object is invalid
using the
ISERROR function. The ISERROR function has one input argument and
returns a boolean value. It returns TRUE if the argument is invalid or returns
FALSE if the argument is valid.
The
ISERROR function is used with the Restart attribute. The ISERROR function
operates on an invalid data object contained within a valid object.