I was wondering if anyone knows how to extract duplicate nodes using an XML Query. For example, some RSS feeds have the "Category" element repeated. See example below;
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?