Skip to main content

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

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.


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?


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.


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 !!!