Pentaho 3.2 Data Integration Beginner's Guide

Time for action – finding out which language people speak

An International Musical Contest will take place and 24 countries will participate, each presenting a duet. Your task is to hire interpreters so the contestants can communicate in their native language. In order to do that, you need to find out the language they speak:

1. Create a new transformation.
2. By using a Get Data From XML step, read the countries.xml file that contains information about countries that you used in Chapter 2.

   Tip

   To avoid configuring the step again, you can open the transformation that reads this file, copy the Get data from XML step, and paste it here.

3. Drag a Filter rows step to the canvas.
4. Create a hop from the Get data from XML step to the Filter rows step.
5. Edit the Filter ...