Talend Open Studio Cookbook

Checking a column against a lookup

Another method for validating a column is to refer to a lookup containing a list of allowed values that can be stored in any format (file, table, XML for example).

Getting ready

Open the job jo_cook_ch03_0050_tMapValuesInLookup.You will see that there are two inputs to the tMap: customer and country.

How to do it…

1. Open tMap, and drag the field countryOfBirth from the customer input to the countryName field in the country input. This will create a key link, as shown in the following screenshot:
   
2. Click the button tMap settings and set the value for Join Model to Inner Join.
3. In the reject output, click on the button for ...