I don't believe a looping functoid is necessary for the problem as defined.
Take a look at the entry "BizTalk Mapping - Flattening Data" at
http://sspsi.com/blog/index.html
Regards,
Jim Dawson
Managing Partner
Second Star
919.548.6521
jim@[EMAIL PROTECTED]
Messenger: jim@[EMAIL PROTECTED]
"Eric Stott" <ericstott@[EMAIL PROTECTED]
> wrote in message
news:%23eRU54AuHHA.2752@[EMAIL PROTECTED]
> Good luck,
> Eric
> http://blog.biztalk-info.com
>
> "Donald Hurley" <DonaldHurley@[EMAIL PROTECTED]
> wrote in
message
> news:6FE5380A-A937-4E72-BC28-F249AF54DDF5@[EMAIL PROTECTED]
>> Nevermind, got it.
>>
>> Thanks for you help.
>> Don
>>
>> "Donald Hurley" wrote:
>>
>>> Eric,
>>>
>>> I am not sure I understand. How do I go about extracting it from the
>>> looping functiod. Doesn't the looping functoid have to have a link
from
>>> the
>>> source, to the destination schemas?
>>>
>>> Thanks,
>>> Don
>>>
>>> "Eric Stott" wrote:
>>>
>>> > You need to put this into a looping functiod and then extract it
from
>>> > the
>>> > looping functiod.
>>> >
>>> > The underlying XSL will only extract the first occurrence, by
putting
>>> > the
>>> > looping functoid in there, it 'resets' the for-each and it will work
>>> > as
>>> > expected.
>>> >
>>> > Eric
>>> > http://blog.biztalk-info.con
>>> >
>>> > "Donald Hurley" <DonaldHurley@[EMAIL PROTECTED]
> wrote in
>>> > message
>>> > news:0ECF4452-BC2F-4AD7-9E30-2CACA0814138@[EMAIL PROTECTED]
>>> > > Hi
>>> > >
>>> > > I am having trouble flattening EDI data.
>>> > >
>>> > > BGM++GBBHXAUSJFKAAUN10485+++ACW:0496++AB'
>>> > > DTM+164:9111120230:201'
>>> > > TDT+20+305+4+++BA:172:3'
>>> > > LOC+5:LHR:163:3'
>>> > > LOC+13:AMS:163:3'
>>> > > DTM+189:9111120800:201'
>>> > > DTM+232:9111120940:201'
>>> > > TDT+20+175+4+++KL:172:3'
>>> > > LOC+5:AMS:163:3'
>>> > > LOC+7:JFK:163:3'
>>> > > DTM+189:9111121100:201'
>>> > > DTM+232:9111121400:201'
>>> > > MEA+WT+AAD+KGM:476.9'
>>> > > MEA+CT+SQ+NMB:8'
>>> > >
>>> > > The 2 mea records at the bottom need to go to different fields in
>>> > > the same
>>> > > record. I use 2 equal functoids to determine if they are AAD or
SQ,
>>> > > and 2
>>> > > Value Mapping (Flattening) functoids to put them into different
>>> > > fields,
>>> > > but
>>> > > they always produce 2 records. In looking at the do***entation an
>>> > > another
>>> > > post in .General "Help on Looping and Value Mapping functoid".
>>> > > This
>>> > > should
>>> > > work. But I am getting 2 records.
>>> > >
>>> > > DIDGBB 911112 ACW0496476.9 AB
>>> > > DIDGBB 911112 ACW0496 8 AB
>>> > >
>>> > > Is this the correct way to go about this? What could I be doing
>>> > > wrong.
>>> > >
>>> > > TIA
>>> > > Don
>>> > >
>>> > >
>>> > >
>>> >
>>> >
>>> >
>
>
|
