XPath node: How to repeat the data from a parent tag

KNIME Analytics Platform
3

Hey @ArjenEX, thank you very much for your answer! It works like a dream.

But I simplified the structure of the example XML a bit because I thought it wouldn’t be a problem. The real structure is:

...
   <song>
        <song_number>2</song_number>
        <song_title>Breathe</song_title>
        <duration>3:57</duration>
        <song_composer>
           <name>Roger Waters</name>
        </song_composer>
        <song_composer>
           <name>David Gilmour</name>
        </song_composer>
        <song_composer>
           <name>Richard Wright</name>
        </song_composer>
        <song_texter>Roger Waters</song_texter>
   </song>
...

The composer should be in a cell at the end, like: [Roger Waters, David Gilmour, Richard Wright]

I thought this would work by reading the <song_composer> as a node cell in the XPath data types and in the tag options as multiple rows and in a second step converting these node cells, as you once explained to me yourself: How do I bring repeating tags from an XML file into a single table cell? - #2 by ArjenEX

But by using the wildcard on the song identifier …/song[*]/… the composers are unfortunately not read in one cell, instead each composer is read in one row, which again invalidates the entire row data set.

So how can I use your good solution and still have all the composers of a song in the corresponding cell?