Transforming CSV to XML

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:

1. 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_catalogue into the Name field and click on Next:

   

2. In step 2...