newbie

wilgartw · October 30th, 2007, 05:27 AM

I am having problems finding the answer to this mainly because i don't know what to search for. i have the following xml

Quote:

quote:

Quote:

<event>
    <tag>123456</tag>
    <details>detail 1</detail>
    <price>2.00</detail>
</event>
<event>
    <tag>123456</tag>
    <details>detail a</detail>
    <price>1.50</detail>
</event>
<event>
    <tag>456789</tag>
    <details>detail again</detail>
    <price>0.99</detail>
</event>
<event>
    <tag>123456</tag>
    <details>detail 1</detail>
    <price>3.25</detail>
</event>
<event>
    <tag>456789</tag>
    <details>detail 1</detail>
    <price>10000.00</detail>
</event>
<event>
    <tag>123456</tag>
    <details>more detail</detail>
    <price>23.00</detail>
</event>
<product>
    <tag>123456</tag>
    <description>product number 1</description>
</product>
<product>
    <tag>456789</tag>
    <description>product number 1</description>
</product>

and i need to gather information from all over the file to produce this

Quote:

quote:123456 - product number 1

Quote:

detail 1 2.00
detail a 1.50
detail 1 3.25
more detail 23.00

456789 - product number 1
detail again 0.99
detail 1 100000.00

i have tried using
<xsl:if test=""> but cannot get it to accept a variable of another tag.

can anyone point me in the right direction.

samjudson · October 30th, 2007, 05:55 AM

Looks like a classic example of grouping to me. I don't suppose you are using XSLT 2.0? In which case <xsl:for-each-group> is your friend.

Otherwise its back to http://www.jenitennison.com/xslt/gro...muenchian.html for the 1.0 version...

/- Sam Judson : Wrox Technical Editor -/

joefawcett · October 30th, 2007, 05:56 AM

I assume your XML has a root element that you haven't shown and is well-formed with matching tags rather than the mish-mash posted?
You basically need a template that matches product and within there process all the event element with the matching tag. So assuming this XML:

Code:

<data>
  <event>
      <tag>123456</tag>
      <details>detail 1</details>
      <price>2.00</price>
    </event>
    <event>
      <tag>123456</tag>
      <details>detail a</details>
      <price>1.50</price>
    </event>
    <event>
      <tag>456789</tag>
      <details>detail again</details>
      <price>0.99</price>
    </event>
    <event>
      <tag>123456</tag>
      <details>detail 1</details>
      <price>3.25</price>
  </event>
  <event>
      <tag>456789</tag>
      <details>detail 1</details>
      <price>10000.00</price>
    </event>
    <event>
      <tag>123456</tag>
      <details>more detail</details>
      <price>23.00</price>
  </event>
  <product>
      <tag>123456</tag>
      <description>product number 1</description>
  </product>
  <product>
      <tag>456789</tag>
      <description>product number 1</description>
  </product>
</data>

you need something like:

Code:

<xsl:stylesheet version="1.0"
    xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" />
<xsl:template match="/">
  <xsl:apply-templates select="*/product"/>    
</xsl:template>

  <xsl:template match="product">
    <xsl:value-of select="tag"/>
    <xsl:text> - </xsl:text>
    <xsl:value-of select="description"/>
    <xsl:text>
</xsl:text>
    <xsl:apply-templates select="/*/event[tag = current()/tag]"/>
    <xsl:text>
</xsl:text>
  </xsl:template>

  <xsl:template match="event">
    <xsl:apply-templates select="details"/>
  </xsl:template>

  <xsl:template match="details">
    <xsl:value-of select="."/><xsl:text>
</xsl:text>
  </xsl:template>
</xsl:stylesheet>

--

Joe (Microsoft MVP - XML)

wilgartw · October 30th, 2007, 07:13 AM

Quote:

quote:Originally posted by joefawcett
I assume your XML has a root element that you haven't shown and is well-formed with matching tags rather than the mish-mash posted?
You basically need a template that matches product and within there process all the event element with the matching tag. So assuming this
Joe (Microsoft MVP - XML)

yes, i have a root element and the tags do match. the xml i have been given to work with has 5 millions lines, and not very obvious tags so i was trying to simplify matters. sorry.

thanks for your help.

i am using xslt 1.0, as i have been working through the tutorials on www.w3schools.com, i have also just ordered "Learning XSLT"
M Fitzgerald. am i learning old technology? should i be jumping straight into XSLT 2.0?

again thanks for your help.

mhkay · October 30th, 2007, 08:23 AM

>should i be jumping straight into XSLT 2.0?

Only you can judge. For many stylesheets, 2.0 will double your productivity and it will enable you to tackle problems that simply couldn't be done with 1.0. On the other hand, at present there are fewer processors available and they work in a smaller number of environments.

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

joefawcett · October 30th, 2007, 09:46 AM

The other improvement to make is to declare a key that retrieves event elements via tag. Then use that instead of the construct I showed. As Michael says, if you are sure you can use a version 2.0 processor, Saxon for example, there's hardly any reason not to use it.

--

Joe (Microsoft MVP - XML)