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

[ Post a follow-up to this message ]

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
>

[ Post a follow-up to this message ]

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
>

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]

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

[ Post a follow-up to this message ]

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.

[ Post a follow-up to this message ]