| Author |
aggregating in a map
|
|
| jemkem@yahoo.com 2006-03-10, 5:54 pm |
| If I have an input XML message that when flattened looks like
persona territory5 10
persona territory4 20
persona territory4 30
personb territory3 10
personb territory3 40
personc territory2 30
personc territory3 50
Is there a way to use the mapper to get
persona territory5 sequence1 10
persona territory4 sequence2 50
personb territory3 sequence1 50
personc territory2 sequence1 30
personc territory3 sequence2 50
In other words, I'd like to aggregate by person by territory and reset
a sequence number whenever person changes. Is the mapping process the
right place to perform this type of operation?
Thanks for your help.
Jay
| |
| Leonid Ganeline 2006-03-10, 8:47 pm |
| You can use the xslt.
But, if you have access to the DB you'd rather add sorting to the DB side
and get the message to BTS also sorted. Mapping is not a good place to
sorting.
--
Regards,
Leonid Ganeline
BizTalk developer
Vancouver
http://geekswithblogs.net/leonidganeline
===================================
<jemkem@yahoo.com> wrote in message
news:1142027013.420971.49310@p10g2000cwp.googlegroups.com...
> If I have an input XML message that when flattened looks like
>
> persona territory5 10
> persona territory4 20
> persona territory4 30
> personb territory3 10
> personb territory3 40
> personc territory2 30
> personc territory3 50
>
>
> Is there a way to use the mapper to get
>
> persona territory5 sequence1 10
> persona territory4 sequence2 50
> personb territory3 sequence1 50
> personc territory2 sequence1 30
> personc territory3 sequence2 50
>
>
> In other words, I'd like to aggregate by person by territory and reset
> a sequence number whenever person changes. Is the mapping process the
> right place to perform this type of operation?
>
>
> Thanks for your help.
> Jay
>
| |
| Greg Forsythe 2006-03-11, 2:47 am |
| Yes this is acheivable in a map.
It requires the use of <xsl:key> and so requires a custom Xslt
I have done this a number of times and it works well
Greg
<jemkem@yahoo.com> wrote in message
news:1142027013.420971.49310@p10g2000cwp.googlegroups.com...
> If I have an input XML message that when flattened looks like
>
> persona territory5 10
> persona territory4 20
> persona territory4 30
> personb territory3 10
> personb territory3 40
> personc territory2 30
> personc territory3 50
>
>
> Is there a way to use the mapper to get
>
> persona territory5 sequence1 10
> persona territory4 sequence2 50
> personb territory3 sequence1 50
> personc territory2 sequence1 30
> personc territory3 sequence2 50
>
>
> In other words, I'd like to aggregate by person by territory and reset
> a sequence number whenever person changes. Is the mapping process the
> right place to perform this type of operation?
>
>
> Thanks for your help.
> Jay
>
| |
| jemkem 2006-03-15, 5:52 pm |
| How do you latch a custom XSLT into a BT project? I've just converted
my first XSLT from a different project into a BizTalk map and found the
process to be quite painful. I'm sure a lot of it has to do with my
unfamiliarity with BT. Some of the things I had to do to convert
seemed downright clunky. If there's a method I could use to leverage
my existing XSLT maps, I'd like to know about it. The only thing I
came up with was using a scripting functoid and putting the whole XSLT
into it.
Thanks for your help!
J
| |
| kstout@amplifier.com 2006-03-15, 5:52 pm |
| 1. Create a new map
2. Specify your source and destination schemas
3. Click on the grid where the functoids go
4. Set the "Custom XSLT Path in the property editor to point to your
..xslt file
voila.
-rks
| |
| jemkem 2006-03-21, 3:10 am |
| Thanks mucho. Just can't find the "go" switch sometimes. I must say,
this is the most responsive newsgroup I've ever used. Thanks so much.
|
|
|
|