Hello,
Thanks Greg, I really appreciate the tip you gave – it worked. I had previously tried using the looping functoid but had also connected the invoice header to it and that output twice the number of output records with incorrect fields.
I had also simplified my input file to get the BizTalk running. It actually looks like this:
Header record
Invoice A header record
Product 1 for Invoice A record
Serial Number record for Product 1
Product 2 for Invoice A record
Invoice B header record
Product 1 for Invoice B record
I.e. Each product record may be followed by a Serial number record. There is also a line item number field on both the Product and Serial Number record to match the two records. All records have a tag identifier.
In the BizTalk map, when I connect the serial# field to the appropriate field in the output record it uses the data from the first Serial number record for all other products in the same invoice. I also tried connecting the Serial Number record to the looping functoid but that produced incorrect result.
How do I show the Product and Serial Number relationship in the mapping?
If the Product quantity is greater than 1 then I would like also like to produce n output records where Product quantity = n (similar to a for each loop). Can this be achieved in BizTalk mapping?
As my questions indicate I’m very new at BizTalk! Are there tutorial/samples available?
Cheers
Stable