Page History

...

invoice_num,date,po,id,[product_code,prod_qty,prod_amt],total

Wiki MarkupAny value within "\[" and "\]" will be treated like a sub item where the column before "\[" will be the driving column, i.e. and change in that item will create a new XML. In this example "id" becomes the *grouping column*.

Wiki MarkupThe split create a node on the element just before "\[" with "list". So in the above example the XML will be like -

<row>
 <invoice_num>value</invoice_num>
 <date>value</date>
 <po>value</po>
 <id id="">
 <list>
 <product_code>value</product_code>
 <prod_qty>value</prod_qty>
 <prod_amt>value</prod_amt>
 </list>
 <list>
 <product_code>value</product_code>
 <prod_qty>value</prod_qty>
 <prod_amt>value</prod_amt>
 </list>
 </id>
 <total>value</total>
 </row>

Now to map, all you have to do is map the target loop structure to "id/list" along with the field maps.