Skip to main content
Solved

Extracting name and description Tags from xml_fragment Using XMLQueryExtractor

  • August 19, 2025
  • 4 replies
  • 58 views

francisco_1988
Contributor
Forum|alt.badge.img+5

Hi everyone,

I’m having some trouble with the XMLQueryExtractor. I need to extract from the xml_fragment field the values inside the <name> and <description> tags.

Currently, the output from FeatureJoiner is in the format:

 

Theme | ID | xml_fragment

What I need is for the extraction to produce the following table:

 

Theme | ID | xml_fragment | name | description

Best answer by takashi

I would recommend you to insert a ListExploder to explode the “field{}” list immediately after the Counter and see how it works firstly. Once you have understood how it works, I think that you can then find how you can use the transformer to achive your goal.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

4 replies

takashi
Celebrity
  • August 19, 2025

Hi ​@francisco_1988 ,

I don't think you need to use XMLXQueryExtractor to extract name and description, since XML reader has extracted those values as a list attribute called "field{}" already.

You can just use ListExploder to extract the values of name and description from the list.


francisco_1988
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • August 19, 2025

Hi ​@francisco_1988 ,

I don't think you need to use XMLXQueryExtractor to extract name and description, since XML reader has extracted those values as a list attribute called "field{}" already.

You can just use ListExploder to extract the values of name and description from the 

I'm not at my workstation right now. Would your suggestion be to insert a list builder after my feature joiner?


takashi
Celebrity
  • Best Answer
  • August 20, 2025

I would recommend you to insert a ListExploder to explode the “field{}” list immediately after the Counter and see how it works firstly. Once you have understood how it works, I think that you can then find how you can use the transformer to achive your goal.


francisco_1988
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • August 20, 2025

I would recommend you to insert a ListExploder to explode the “field{}” list immediately after the Counter and see how it works firstly. Once you have understood how it works, I think that you can then find how you can use the transformer to achive your goal.

Thank you !!!