1. Converting CSV to XML for Data Import
Data AnalystBackground
An analyst needs to import a list of employees from a CSV file into an HR system that only accepts XML.
Problem
The CSV format is incompatible with the HR system's strict XML schema requirements.
How to use
Paste the CSV data, set Input Format to 'CSV', and define 'employee' as the row element.
rootElement: 'employees', rowElement: 'employee', prettyPrint: trueOutcome
A clean, indented XML file with an <employees> root and individual <employee> nodes for each record.