MQSeries.net :: View topic - DataInsert and Mapping : Could not map repeating XML element

mbroker · Posted: Fri Jan 13, 2012 2:48 pm Post subject:

Hi,

I am using the DataInsert node to insert XML message to a table. The XML message contains few repeating elements without child elements. The table contains separate fields for each of this element. When I went to the mapping editor and dragged the xml element to the first column corresponding to the repeating XML element, I saw a for row inserted in the spreadsheet view which I think is OK. But, all the other mappings are inside this for including the mapping of non-repeating elements.

XML structure:
<body>
<e1>element1</e1>
<e2>element21</e2> 
<e2>element22</e2>
<e3>element3</e3>
</body>

Table columns:
e1
e21
e22
e3

Mapping needed:
<e1> --> e1
<e2> --> e21
<e2> --> e22
<e3> --> e3

What I see

for $source/body/e2
$db:insert
e1 -- $source/body/e1
e21 -- $source/body/e2
e3 -- $source/body/e2

What I need is when there are 2 entries of e2, I want e21 populated with the first entry of e2 and e22 populated by the second entry of e2.

I am not able to move the "for" inside the db:insert row to conditionally populate e21 and e22.

Is this something DataInsert node can do? Or, what is the best alternative?