Often it is necessary to ensure that a column contains only values as defined in a list. This recipe shows how this can be achieved using a
Open the job
jo_cook_ch03_0040_tMapValuesInList. You will notice that the job is very similar to the previous recipe Rejecting rows using tMap.
tMapand click the expression builder button (…), and add the test criteria, as shown in the following screenshot:
The tMap conditions are the same as Java conditions, so the symbol || (pipe pipe) ...