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 file with information about countries that you used in Chapter 3, Manipulating Real-world Data, countries.xml.

    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 to the canvas a Filter rows step.
  4. Create a hop from the Get data from XML step to the Filter rows ...

Get Pentaho Data Integration Beginner's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.