| Gregory Britt 2005-02-01, 5:59 pm |
| Hello everyone. Please excuse my ignorance on this subject as I'm relatively
new to Biztalk in general, but this is something I've been struggling on for
about a week now.
I have a source schema that has a sequence group of two records that
ultimately contains all the information for a specific item on a purchase
order.
For example:
03....<item number>...<UPC>...etc
04....<description>...<weight>...etc
This sequence occurs in unbounded fashion.
I have been asked to map each sequence to a single output record.
For example:
<item number>,<UPC>,<description>,<weight>
The problem I'm having, is that I've had zero luck trying to get each record
matched up on a single output. I've gotten to the point through table
looping that I can get all the unique items from one record, but I only get
the first line of the opposite record.
ie. If my input looks like:
03 12345 0987654321
04 WIDGET 10OZ
03 54321 1234567890
04 GEAR 16LB
03 89001 0000000000
04 HAMMER 1GM
....the best I've been able to get is:
12345,0987654321,WIDGET,10OZ
54321,1234567890,WIDGET,10OZ
89001,0000000000,WIDGET,10OZ
(or vice versa)
All of the looping structures I've tried have failed, because I don't seem
to be able to use the actual sequence "element" in any type of controlling
fashion.
If anyone has any suggestions, or could point me out to something that I'm
missing, I would greatly appreciate it.
Thank you for the help,
~Greg
|