Re: Trouble Flattening EDI data

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