Data Transformation Engine Design Studio Tutorial

Chapter 6 - Using the OR Function with a Lookup File Extracting Contacts that are Preferred

Design Studio Tutorial

147

Building and Running the MakePreferredData Map

♦ Build and run the MakePreferredData map.

♦ View the run results.

The lookup.txt output file is displayed.

Extracting Contacts that are Preferred

The ContactToFullLabel map generates the full list of customer records.

♦ Add an input card to the ContactToFullLabel map with the lookup.txt file as

the data source.

! The CardName should describe the input. Name the card LookupFile.

! The TypeTree must describe the input. Select the Preferred type tree.

! The Type must represent the data object of the card. Select

Preferred File Data.

♦ Edit a setting on the output card to generate the PreferredLabels.txt.

♦ Modify the map rule that generates the functional map to use the

OR function.

The

OR function evaluates a series of conditions and returns TRUE if at least one

condition evaluates to TRUE, otherwise returns FALSE. You can use the

function when you want to test if one of a series of conditions is true.