Double-click the tFileInputXML component labeled
USStates to open its Basic
settings view.
Click the [...] button next to Edit
schema and in the Schema
dialog box define the schema by adding one column USState of Document
type.
Click OK to validate the changes and close the dialog
box. One row is added automatically to the Mapping table.
In the File name/Stream field, browse to or enter
between double quotation marks the path to the XML source file that holds the
complementary data. In this scenario, it is
E:/USState.xml.
In the Loop XPath query field, enter an XPath
expression between double quotation marks to specify the node on which the loop
is based. In this scenario, it is /, which
means to perform look query from the root.
In the XPath query column of the Mapping table, enter the fields to be queried between double
quotation marks. In this scenario, it is .,
which means all fields under the current node (root) will be extracted.
In the Get Nodes column of the Mapping table, select the check box. This retrieves
the XML structure for the Document type
data.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!