Re: Trouble Flattening EDI data

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