|
Home > Archive > BizTalk Server General > December 2004 > looping issue going from xml to flat file
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
looping issue going from xml to flat file
|
|
| mltothppg 2004-12-03, 5:52 pm |
| I am mapping xml to a positional flat file and the xml has a number of
comments that are contained in one tag that is looped possibly
hundreds of times. The tag in the xml contains only one sentence for
each iteration in the loop. I am mapping this to a flat file record
that is 800 characters in length with 10 fields of 80 characters each.
Right now I am using a looping functiod and I am mapping each
iteration of the data to a single field in the record creating a new
flat file record for each iteration of the data in the xml. Is it
possible to have counter keep track of each iteration of the inbound
data and map each iteration to a different field in the destination
flat file record until it reaches the 10th field, then start over with
another record and keep going from there? Hopefully that made sense.
I know there is an iteration functoid in the mapper, but I cant see
how you would tell it to create a new record in the destination flat
file after the 10th iteration.
Thanks,
Mike
mtoth@ppg.com
| |
| Everett Yang 2004-12-06, 5:49 pm |
| What you can do here is to generate more outbound records then what is
needed and suppress the ones you don't want. You'll need a looping
functoid and then use logical functoid with the outbound record. We
suppress the outbound record whenver the logical functoid is false.
You will probably need a scripting functoid to keep track of the
iterations. I am not 100% sure that would be necessary without actually
working on the map.
From your description, a map may be possible but it is going to be a
complex one.
Sincerely,
Everett Yang
DSI - Microsoft BizTalk Server
This posting is provided “AS IS” with no warranties, and confers no rights.
Subscribe at
http://support.microsoft.com/defaul...msdn/nospam.asp
&SD=msdn
|
|
|
|
|