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.properties
file located in theC:/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
Make sure that the directory specified in
kettle.properties
exists.Save the file.
Restart Spoon.
Create a new transformation.
Give a name to the transformation and save it in the same directory you have all the other transformations.
From the Packt website, download the
resources
folder containing a file namedcountries.xml
. Save the folder in your working directory. For example...