Data Transformation Engine Design Studio Tutorial
Chapter 6 - Using the OR Function with a Lookup File Extracting Contacts that are Preferred
Design Studio Tutorial
148
In this case, you want to test if the Company Field in the Contact group (which
is a component of ContactFile) is equal to the Company Field in the Customer
group (a component of LookupFile). Your map rule should look like this:
Note To view help on any function, place current focus on that function in the Insert
Function dialog box and press F1.