O'Reilly logo

Pentaho Data Integration Beginner's Guide by María Carina Roldán

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required