Transforming Files - Getting Started with Talend Open Studio for Data Integration - page 32

Before we dive in and actually start to configure a the Studio job, let's look at the
data that we want to transform. Our input file is an XML product catalogue named
catalogue.xml , which is present in the datafiles of this chapter. Open this in the
XML viewer of your choice. You can see that the data is pretty self-explanatory.
The file contains data about Stock Keeping Units ( SKUs ). There are a number of
repeating SKU elements, each containing an skuid, skuname, size, colour, and price.

We want to extract this data into a spreadsheet-style format with similar columns
to the XML elements, that is skuid, skuname, size, colour, and price.

So let's create the job step-by-step:

1. Create a new job in the Studio and name it XML2CSV . (I've also created a new

folder named Chapter3 to contain the jobs for this chapter and I'll follow this
convention for other chapters throughout the topic.)