Skip to main content Skip to complementary content

Configuring the input flow for lookup

Procedure

  1. Double-click the tFileInputXML component labelled USStates to open its Basic settings view.
  2. Click the [...] button next to Edit schema and in the Schema dialog box define the schema by adding one column USState of Document type.
  3. Click OK to validate the changes and close the dialog box. One row is added automatically to the Mapping table.
  4. In the File name/Stream field, browse to or type in between double quotation marks the path to the XML source file that holds the complementary data. In this scenario, it is E:/USState.xml.
  5. In the Loop XPath query field, type in 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.
  6. In the XPath query column of the Mapping table, type in 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.
  7. 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!