Learning Pentaho Data Integration 8 CE - Third Edition

Looking for data using a Database join step

The Transformation that we will create takes pairs of words as input and looks for films whose description contains both words. For example, if the words are robot and rocket, what we want is the same as the output of the following SQL statement:

SELECT title, descriptionFROM public.filmWHERE description like '%robot%' and description like '%rocket%'

Just for simplicity, as input, we will write the words in a Data Grid but the source of the lookup can be any stream.

This is how we do this:

1. Create a Transformation.
2. Add a Data Grid step. Define two String fields named word1 and word2.

3. Fill in the Data tab as follows or with your own set of words:

Sample input data

4. After the Data Grid, add a ...