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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access