In the example above I have set the <ROWS> in the query like this <ROWS>/root/item</ROWS>. This works fine and maps all the columns as expected. If there are 3 <ITEM> nodes then i get 3 rows. But the problem is that within each <ITEM> node of the RSS feed I am mapping the <CATEGORY> element which can repeat multiple times. When there are duplicate elements only one of the duplicates is mapped (cant remember if its the first or last).

So is it possible to map duplicates.. perhaps map them to the target as comma separated values?

While playing around with an XML query i accidentally stumbled upon something interesting in the debugging output. I left the "ROWS" and "COLUMNS" tags empty and just placed "rss" into the transform source below and to my surprise OWS seemed to parse the entire XML and create multiple output tables. See Query & Results below. It even seemed to create "ID" columns for the parent/child relationships between parent and child nodes. ie; "rss_Id", "channel_id" etc. So the million dollar question is ... How can i read the data in the tables. As it stands all know to do at the moment is loop through the data from the first table returned. Is there a way to loop through the other tables returned. Thanks

Now the thread is very very old but having spent two days trying to find the XPATH to extract some XML I'm just about to give up again.
In debug my XML seems to be in separate tables. I can access the top (first) table but not the others.
eg,