Advanced transformations

To transform the XML document to columns and rows, XML Input uses an XSLT stylesheet that it generates from the XPath expressions that are specified on the input link.

If the XML document contains nodes whose relationships are not explicit, XML Input may not be able to automatically perform the transformation. As an alternative to the generated XSLT stylesheet, you can substitute your own stylesheet.

The following provides the following information about transforming XML documents using custom XSLT stylesheets in the XML Input stage:

• Document Type Definition (DTD) to which the output of an XSLT stylesheet must conform
• Procedure for accessing the generated XSLT stylesheet
• Sample input document for which you might use a custom XSLT stylesheet
• Sample XSLT stylesheet that converts the input document to an XML document that conforms to the required DTD
• Generated internal XML document
• Generated output rows, which are available on an output link