August 15, 2023

Extracting exact match – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Extracting exact match – Docs for ESB 6.x

Extracting exact match

  1. Double-click tExtractXMLField to display
    the component Basic settings view.

    use_case-tstandardizerow-index_rules7.png

  2. Click the […] button next to the
    Edit schema field to open the schema
    editor, add four columns in the output flow and name them as
    Brand, Range,
    Color and Amount. Click
    OK to validate and close the
    editor.

    use_case-tstandardizerow-index_rules6.png

  3. In the XML field field, check that the
    STANDARDIZED_FIELD column is
    selected.

    The content of the STANDARDIZED_FIELD
    column is an XML field with a <record> tag as root. Under
    this tag, the structure defined by the rules configured in the tStandardizeRow component allows to extract items
    from the input flow.
  4. In the Loop XPath query field, enter “/”
    to define the root as the loop node.
  5. In XPath query field in the Mapping table, enter respectively
    “record/Brand”,
    “record/Range”
    “record/Color”
    and “record/Measure”.
  6. Double-click tFileOutputExcel to display
    the component Basic settings view.

    use_case-tstandardizerow-index_rules8.png

  7. Set the destination file name as well as the Sheet name and select the
    Include header check box.
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