-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Pentaho Data Integration 4 Cookbook

In the previous recipe, you saw how to search for columns in a database table based on simple conditions. With Kettle, you can also search by providing complex conditions or involving more than one table. In this recipe, you will learn how to perform that kind of search by using the Database join step.
In order to let you compare the different options for searching data in a database with ease, we will work with the same example that you saw in the preceding recipe: the Steel Wheels sample data. You want to look for products that match a given search term and whose prices are below a given value.
In order to follow this recipe, you need the Steel Wheels database.
Carry out the following steps:
Create a new transformation.
Create a stream that generates a dataset like the one shown in the following screenshot:
You can type the data into a file and read the file, or use a Data Grid...
Change the font size
Change margin width
Change background colour