Re: Trouble Flattening EDI data

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