Re: Trouble Flattening EDI data

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
>> > >
>> > >
>> > >
>> >
>> >
>> >