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.
- If you work under Windows, open the
kettle.propertiesfile located in the
C:/Documents and Settings/yourself/.kettlefolder and add the following line:
On the other hand, if you work under Linux (or similar), open the
kettle. propertiesfile located in the
/home/yourself/.kettlefolder and add the following line:
- Make sure that the directory specified in
- Save the file.
- Restart Spoon.
- Create a new transformation. ...