Hi Martin,

I have tried your xslt and it works fine.

I would like to express my sincere thanks for your help and source code.

Please could you explain to us the key you created?

<xsl:key name="k1" match="Ad" use="concat(ancestor::Vehicle/@key, '|', Position/@name)"/>

1 - Why are you using concat to create a key with two values i.e. vehicle key and position name?

2 - how did you realise that it was necessary to have a concat for the key?

It was trying to group using only Position/@name so I would never have got it right :-(

Cheers

As far as I understand your sample input and output you want to group the "Ad" elements for each "Vehicle" (respectively for each "Vehicle/@key") that is why it is necessary to use a key value that concatenates the "key" attribute value with the "name" attribute value. If we defined the key only on the "Position/@name" attribute value we would get groups containing "Ad" elements of different "Vehicle" ancestors.

__________________
Martin Honnen
Microsoft MVP (XML, Data Platform Development) 2005/04 - 2013/03
My blog

Hi Martin,

Thanks for the explanation.

It is spot on.