|
Home > Archive > BizTalk Server Applications Integration > February 2005 > Looping to single line
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Looping to single line
|
|
|
| This situation has come up now twice, and I was wondering if anyone else has
come across this and has a resolution for this:
I have an EDI document that has an AMT loop, I need to map two values to a
single line, example
....
AMT*1*3.54
AMT*LI*8.67
....
I need to map it to a single line, the first field need to be the AMT(02)
where AMT(01) is LI and the second field in the line needs to be populated
with the AMT(02) where AMT(01) is 1.
It should look like this
LINE|8.67|3.54
When I use two equal functoids connected to the value mapping(flattening)
functoid, this is the result I get:
LINE|8.67||
I cannot guarantee the order of the AMT segments, and I am stumped on how I
can get both of these values.
PLEASE HELP
| |
| Nabeel Prior 2005-02-24, 2:47 am |
| Eric,
It sounds like you may need to use the Table Looping fuctoid. Have a look
at this blog entry for a sample of how it works:
http://geekswithblogs.com/sthomas/a.../28/13982.aspx. Although
the sample does not address exactly what you need, it may help you with what
you are trying to achieve.
--
Kind Regards,
Nabeel Prior
Web: http://www.brainjar.co.za
Blog: http://www.brainjar.co.za/blog.aspx
"Eric" <ericstott.dnsme@hotmail.com> wrote in message
news:eZXDggbGFHA.3076@tk2msftngp13.phx.gbl...
> This situation has come up now twice, and I was wondering if anyone else
> has
> come across this and has a resolution for this:
>
> I have an EDI document that has an AMT loop, I need to map two values to a
> single line, example
>
> ...
> AMT*1*3.54
> AMT*LI*8.67
> ...
>
> I need to map it to a single line, the first field need to be the AMT(02)
> where AMT(01) is LI and the second field in the line needs to be populated
> with the AMT(02) where AMT(01) is 1.
>
> It should look like this
>
> LINE|8.67|3.54
>
> When I use two equal functoids connected to the value mapping(flattening)
> functoid, this is the result I get:
>
> LINE|8.67||
>
> I cannot guarantee the order of the AMT segments, and I am stumped on how
> I
> can get both of these values.
>
> PLEASE HELP
>
>
|
|
|
|
|