While XML is a very flexible format but this flexibility brings problems, for example, one of the tags can be optional or tags order can be changed.

XSLT provides an easy way of transforming XML data into the standard format. XSLT can be applied during loading the data or in the latest version of Advanced ETL Processor and Visual Importer ETL using package action

Note: XSLT stands for EXtensible Stylesheet Language, and is a style sheet language for XML documents. XSLT stands for XSL Transformations.

Package Example

XSLT Package

 

XSLT Transformation Package Action

XSLT Transformation Examples
  1. How to Transform a Simple XML file
  2. How to Transform a Complex XML file
  3. How to Convert XML Attributes
  4. How to Convert XML into CSV using XSLT 
Direct link, no registration required.