need help on XSLT

misanaka · March 22nd, 2007, 10:49 PM

HI XSLT/XPATH gurus,

i have the following xml:
<acord>
  <vehicles>
    <vehiclenumber>1</vehiclenumber>
   </vehicles>
  <vehicles>
    <vehiclenumber>2</vehiclenumber>
  </vehicles>
  <coverages>
     <covcd>bi</covcd>
     <vehiclenumber>1</vehiclenumber>
      <amt>100</amt>
  </coverages>
  <coverages>
     <covcd>pd</covcd>
     <vehiclenumber>1</vehiclenumber>
      <amt>100</amt>
  </coverages>
<coverages>
     <covcd>bi</covcd>
     <vehiclenumber>2</vehiclenumber>
      <amt>100</amt>
  </coverages>
<coverages>
     <covcd>pd</covcd>
     <vehiclenumber>2</vehiclenumber>
      <amt>100</amt>
  </coverages>
<coverages>
     <covcd>um</covcd>
     <vehiclenumber>1</vehiclenumber>
      <amt>100</amt>
  </coverages>
<coverages>
     <covcd>um</covcd>
     <vehiclenumber>2</vehiclenumber>
      <amt>100</amt>
  </coverages>

</acord>

i need following out put how to achieve this.

<vehicles>
<vehiclenumber>1</vehiclenumber>
<coverages>
<covcd>um</covcd>
     <vehiclenumber>1</vehiclenumber>
      <amt>100</amt>
</coverages>
<coverages>
     <covcd>bi</covcd>
     <vehiclenumber>1</vehiclenumber>
      <amt>100</amt>
  </coverages>
  <coverages>
     <covcd>pd</covcd>
     <vehiclenumber>1</vehiclenumber>
      <amt>100</amt>
  </coverages>
</vehicles>

any help is greatly appreciated.i can have n number of vehicles. n number of coverages for each vehicles.

Thanks,
Misanaka

joefawcett · March 23rd, 2007, 01:04 AM

I would suggest a template that matches vehicles and within this apply-templates to a coverages element where vehiclenumber is equal to the current vehiclenumber. Finally a template that matches coverages.

--

Joe (Microsoft MVP - XML)

mhkay · March 23rd, 2007, 03:54 AM

Not quite sure how your output relates to your input but it looks like a classic grouping problem. Use xsl:for-each-group if you're in XSLT 2.0, or Muenchian grouping (much trickier) in 1.0. For Muenchian grouping see your favourite Wrox textbook or http://www.jenitennison.com/xslt/grouping

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

joefawcett · March 23rd, 2007, 04:23 AM

That was my first thought but looking at the XML it seems simpler:

Code:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0">
    <xsl:template match="/">
      <vehicles>
        <xsl:apply-templates select="*/vehicles"/>
      </vehicles>
    </xsl:template>

    <xsl:template match="vehicles">
      <xsl:copy-of select="vehiclenumber"/>
      <xsl:apply-templates select="../coverages[vehiclenumber = current()/vehiclenumber]"/>
    </xsl:template>

    <xsl:template match="coverages">
      <xsl:copy-of select="."/>
    </xsl:template>
</xsl:stylesheet>

Personally I think the output is a poor design, it will be difficult to process, especially in XSLT 1.0 as the information is contained somewhat in the position of the elements. Better to surround each vehicle and its coverages with a vehicle element.

--

Joe (Microsoft MVP - XML)

misanaka · March 23rd, 2007, 11:24 AM

Thanks joefawcett

I solved the problem with your help.

Misanaka

misanaka · March 23rd, 2007, 11:26 AM

Thanks mhkay

For your suggestion i solved it using for-each loop.and

Misanaka