Data Transformation Engine Map Designer Reference Guide

Chapter 15 - Managing Invalid Data Using the REJECT Function
Map Designer Reference Guide
235
Error Report Example
The following purchase order data is invalid:
H 1422,04/23/97,TSI,Bennison’s Bakery
M Urgent,Please hurry
D Turtle,10,1.27
D Choc Chip Cookie,20,.34
T Lewis,042497
H 1379,05/09/97,TSI,Alpha Water
Sports
D Jet Skis,3,135.75
D Snorkle,4,13.35
D Inflatable boat,1,145.55
T Valerie,05/16/97
H 1770,05/10/97,TSI,Saxon's
M Not urgent,Deliver in back
D Backpack,3,12.89
D Hiking boots,4
T Sheila,06/22/97
Bad data
Bad data
There are a total of three purchase orders. The first and the third are invalid.
To map the purchase orders to an invoice, and to map any invalid PO to an error
report. Assign the restart attribute on the PO component in the Type Designer to
map the invalid purchase orders.
Define the output error report in a type tree.
♦ Define the error report to begin with a simple heading “These are the
invalid purchase orders”.
♦ Each invalid PO is considered a stream of text.