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.

In this input file of four customers, the third customer record is invalid:

Gisela,1252 S. Broward/Ft. Lauderdale,523-2622,22

Dede,1513 Palatine Rd./Boca Raton,252-6560,86

Lewis,74099 S. 67th Ave/Ft. Lauderdale,332-8665,3.3

Eric,6933 Main St./South Miami Beach,291-7281,56

To generate a report that indicates whether each customer object is valid, assign a Restart attribute to Customer(s) in the input.

The output report is composed of Line(s), where Line is defined as a text item. The map rule on Line uses the ISERROR function to check whether Customer is invalid. If Customer is invalid, the result is INVALID Customer Data and the REJECT of Customer. If Customer is valid, the result is GOOD Customer Data and the TEXT conversion of the Customer object itself.