Configuring tXMLMap with multiple loops - Cloud - 8.0

tXMLMap

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Processing components (Integration) > tXMLMap
Data Quality and Preparation > Third-party systems > Processing components (Integration) > tXMLMap
Design and Development > Third-party systems > Processing components (Integration) > tXMLMap
Last publication date
2024-02-20

Procedure

  1. Double-click the tXMLMap component to open its Map Editor.
    Note that the input area is already filled with the default basic XML structure and the top table is the main input table.
  2. In the row1 input table, right-click the doc node and from the contextual menu select Import From File. In the pop-up dialog box, browse to the XML source file to import therefrom the XML structure used by the data to be received by tXMLMap. In this scenario, the XML source file is ProductsIn.xml, which contains the input data to tFileInputXML.
  3. In the imported XML tree, right-click the manufacturer node and from the contextual menu select As loop element to set it as the loop element. Then do the same to set the types node and the sale node as loop elements respectively.
  4. On the lower part of the map editor, click the Schema editor tab to display the corresponding view. Then on the right side of this view, add one column outDoc of Document type to the schema table. The corresponding XML root is added automatically to the output table on the top right side which represents the output flow.
  5. In the outDoc output table, import the XML data structure to be used from the XML file that contains the expected output data and provides the expected XML structure. In this scenario, this file is ProductsOut.xml
    Right-click the sale node in the output table and select As loop element from the contextual menu. Then do the same to set the manufacturer node and the types node as loop elements respectively.
  6. In the row1 input table, click the @category node and drop it to the Expression field of the @category node in the outDoc output table.

    Do the same to map other nodes from the input table to the output table:

    • the @name node to the @name node,

    • the @unit node under the summary node to the @unit node,

    • the @id node to the @id node and to the manufacturer_id node respectively,

    • the @date node to the @date node,

    • the name node to the @name node under manufacturer,

    • the type node to the type node,

    • the @type node to the @sales_type node, and

    • the income node to the sale (loop) node.

  7. On the top of the outDoc output table, click the wrench icon and set the value of the All in one property to true to generate a single XML flow. For further information about the All in one feature, see Outputting elements into one document.
  8. Click the [...] button next to the manufacturer loop element and in the pop-up Configure source loops dialog box click the [+] button to add one source loop manufacturer. Do the same to add one source loop sale for the sale loop element.
  9. Click the [...] button next to the types loop element and in the pop-up Configure source loops dialog box add two source loops types and manufacturer. Make sure the sequence number of the types source loop is 0 so that the relative part of the output flow will be sorted based on the values of the type element.

    When a loop element receives mappings from more than one loop element of the input flow, it allows you to set the sequence of the input loops. For example, the types loop element of the output flow in this scenario is mapped with the @id node which belongs to the manufacturer loop element and the type node which belongs to the types loop element of the input flow. The output flow will be sorted according to the primary types loop.

  10. Click OK to validate the mappings and close the Map Editor.