This Example Demonstrates how to Convert simple XML into a delimited file

Source XML

Here is an XML example, it is very well structured therefore there no need to perform additional transformations.

<Table>
<Record>
<ID>1</ID>
<Company>James Bond Production</Company>
<Amount>13</Amount>
</Record>
<Record>
<ID>2</ID>
<Company>Green Cloud</Company>
<Amount>14</Amount>
</Record>
</Table>

Steps to follow

  • Download and install Advanced ETL Processor [Link]
  • Download and Unzip example [Link]
  • Create a new transformation and open the .ats file

XML ETL Transformation 

  • Double click on the reader and select source.xml file

XML Reader

  • Repeat the process for the data writer (Point it at the result.csv file)

ETL Data Writer

  • Run the transformation by pressing the green arrow.

Please contact us if you need help with transforming the data

Visit ETL Tools Forum