Working the other way around, we will now transform a simple CSV file into an XML format. Again, this is a common integration scenario, where, for example, data needs to move from a spreadsheet to a format suitable for loading into another application via its native API.
Start by creating a new job in the Chapter3 folder and call it CSV2XML. We're going to use the CSV output from our previous task as an input file this time, so take a copy of catalogue-out.csv from your DataOut folder and drop it into the DataIn folder. To avoid confusion, let's rename this to csv2xml-catalogue.csv.
As in the previous example, we'll start by declaring the metadata for the input file before completing the main configuration of the job. Perform the following steps:
In the Metadata section of the Repository window, right-click on File delimited and select Create file delimited. The metadata wizard window will appear. Enter
csv_catalogueinto the Name field and click on Next:
In step 2...
