Thanks Greg.
With the flat file schema and mapping as you suggested I only get 1 output record for Invoice A (expected 2 records) . When I connect the looping funtoid from product record to the output record I get the correct number of output records for each invoice but incorrect serial number on the 2nd product of the invoice.
I have now also connected the looping functoid from the sibling Serial Number record to the output record. The XML output now consists of all product records plus the serial number records that exists (different record formats for each record type but each record containing fields to uniquely identify the invoice and line item number).
I've also looked at Stephen Thomas' Sorting, Grouping, and Debatching in Pure Messaging Sample for BizTalk 2004. Will try to sort and group the records by products using the invoice number and line item number as the key.
Can anyone tell me how to define an xsl composite key ?
After the records are grouped by composite key, I somehow need to output the data from the grouped records to one record per group in a flat file. Any hints for this step?
Cheers
Stable