Time for action – getting data from an XML file with information about countries

In this tutorial you will build an Excel file with basic information about countries. The source will be an XML file that you can download from the Packt website.

  1. If you work under Windows, open the kettle.properties file located in the C:/Documents and Settings/yourself/.kettle folder and add the following line:
    LABSOUTPUT=c:/pdi_files/output

    On the other hand, if you work under Linux (or similar), open the kettle.properties file located in the /home/yourself/.kettle folder and add the following line:

    LABSOUTPUT=/home/yourself/pdi_files/output
  2. Make sure that the directory specified in kettle.properties exists.
  3. Save the file.
  4. Restart Spoon.
  5. Create a new transformation. ...

Get Pentaho 3.2 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.

Start your free trial