August 15, 2023

Configuring the process of extracting the XML fields of interest – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Configuring the process of extracting the XML fields of interest – Docs for ESB 6.x

Configuring the process of extracting the XML fields of interest

To do this, proceed as follows

  1. Double click tExtractXMLField to open
    its Component view.

    Use_Case_tStandardizeRow6.png

  2. Next to Edit schema, click the
    three-dot button to open the schema editor.

    Use_Case_tStandardizeRow7.png

  3. On the left side of this editor, select the
    SKU_Description_Size_Weight row.
  4. Click the

    Schema_icon_RightArrow.png

    button to add this row to the right side of the
    editor.

  5. On the right side of this editor, click the plus button on the bottom
    toolbar three times to add three rows.
  6. Rename the three rows as SKU,
    Size, Weight, all of which
    are tags of the normalized XML data.
  7. Click OK to validate this editing and
    accept the schema propagation prompted by the pop-up dialog box. Four
    rows are automatically filled in the Mapping table on the Component view.
  8. In the XML field field of the
    Component view, select the desired
    XML field of the incoming data. In this example, it is
    Normalized_field.
  9. In the Loop XPath Query field, type
    in the name of the XML Tree root tag to replace the default value. In
    this example, type in "/record".
  10. In the XPath query column of the
    Mapping table, type in the XML Tree
    tags corresponding to desired normalized data between quotation marks.
    In this example, they are "SKU", "Size",
    "Weight".
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x