August 15, 2023

Configuring the input flow for lookup – Docs for ESB 6.x

Configuring the input flow for lookup

  1. Double-click the tFileInputXML component labelled
    USStates to open its Basic
    settings
    view.

    Use_Case_tXMLMap4.png

  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.

    Use_Case_tXMLMap13.png

  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.

Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x