Need help in XSLT

Ranch Hand

Posts: 31

posted 23 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Guys,
I'm posting a silly problem once again. Hope somebody will be able to give me some clue.
I'm posting XML as well as XSL files here with this message. All I need to do is to display Comparison Table for Quarterly Attribute Table differently from others but identifier (xsl:when and condition) doesn't work properly. My program shows all the tables.
There are TemplateNodeIDs on the top and matching all of them with the TemplateNodeIDs of tables in Documents, all three types of tables are compared.
Format of Comparison Quarterly Attribute Table should be like this:

XML file:

<?xml version="1.0"?>
<ComparisonDocument Title="Title - 1" ComparisonDocumentID="1">
<View>
<ComparisonTable TemplateNodeID="13" Year="1999">
<Attribute ID="1" />
<Attribute ID="2" />
</ComparisonTable>
<ComparisonTable TemplateNodeID="T3" Year="1999">
<Attribute ID="1" />
<Attribute ID="2" />
</ComparisonTable>
<ComparisonTable TemplateNodeID="T1" Year="1999">
<Attribute ID="1" />
<Attribute ID="2" />
</ComparisonTable>
<ComparisonTable TemplateNodeID="T2" Year="2000">
<Attribute ID="1" />
<Attribute ID="2" />
<Attribute ID="3" />
<Attribute ID="7" />
</ComparisonTable>
</View>
<Document Title="Document One" DocumentID="1">
<Section>

<Item Type="QuarterlyAttributeTable" Title="Doc1 - Quarterly Attribute Table - 1" DisplayType="TableDisplayType" TemplateNodeID="13">
<Row>
<AttrName ID="1">X1</AttrName>
<AttrValue>Value of Year 1999 attr X Q1</AttrValue>
<AttrValue>Value of Year 1999 attr X Q2</AttrValue>
<AttrValue>Value of Year 1999 attr X Q3</AttrValue>
<AttrValue>Value of Year 1999 attr X Q4</AttrValue>

</Row>
<Row>
<AttrName ID="2">Y1</AttrName>
<AttrValue>Value of Year 1999 attr Y Q1</AttrValue>
<AttrValue>Value of Year 1999 attr Y Q2</AttrValue>
<AttrValue>Value of Year 1999 attr Y Q3</AttrValue>
<AttrValue>Value of Year 1999 attr Y Q4</AttrValue>

</Row>

<Row>
<AttrName ID="3">X2</AttrName>
<AttrValue>Value of Year 2000 attr X Q1</AttrValue>
<AttrValue>Value of Year 2000 attr X Q2</AttrValue>
<AttrValue>Value of Year 2000 attr X Q3</AttrValue>
<AttrValue>Value of Year 2000 attr X Q4</AttrValue>

</Row>
<Row>
<AttrName ID="4">Y2</AttrName>
<AttrValue>Value of Year 2000 attr Y Q1"</AttrValue>
<AttrValue>Value of Year 2000 attr Y Q2"</AttrValue>
<AttrValue>Value of Year 2000 attr Y Q3"</AttrValue>
<AttrValue>Value of Year 2000 attr Y Q4"</AttrValue>

</Row>
</Item>
<Item Type="SimpleAttributeTable" TemplateNodeID="T3">
<Row>
<AttrName ID="1">
<b>Doc</b> 1 T1 AttrName 1
</AttrName>
<AttrValue>
<b>12</b>
</AttrValue>
</Row>
<Row>
<AttrName ID="2">Doc 1 T1 AttrName 2</AttrName>
<AttrValue><b>133</b></AttrValue>
</Row>
<Row Year="2001">
<AttrName ID="3">Doc 1 T1 AttrName 3</AttrName>
<AttrValue>145</AttrValue>
</Row>
<Row Year="2002">
<AttrName ID="4">Doc 1 T1 AttrName 4</AttrName>
<AttrValue>167</AttrValue>
</Row>
</Item>
<Item Type="AnnualAttributeTable" TemplateNodeID="T1">
<Row>
<AttrName ID="1">
<b>Doc</b> 1 T1 AttrName 1
</AttrName>
<AttrValue>
<b>12</b>
</AttrValue>
</Row>
<Row>
<AttrName ID="2">Doc 1 T1 AttrName 2</AttrName>
<AttrValue><b>133</b></AttrValue>
</Row>
<Row Year="2001">
<AttrName ID="3">Doc 1 T1 AttrName 3</AttrName>
<AttrValue>145</AttrValue>
</Row>
<Row Year="2002">
<AttrName ID="4">Doc 1 T1 AttrName 4</AttrName>
<AttrValue>167</AttrValue>
</Row>
</Item>
</Section>
<SubSection Title="Introduction" ID="2"> 
<Item Type="AnnualAttributeTable" TemplateNodeID="T2">
<Row Year="1999">
<AttrName ID="1">Doc 1 T2 AttrName 1</AttrName>
<AttrValue>test0</AttrValue>
</Row>
<Row Year="2000">
<AttrName ID="2">Doc 1 T2 AttrName 2</AttrName>
<AttrValue>test1</AttrValue>
</Row>
<Row Year="1998">
<AttrName ID="3">Doc 1 T2 AttrName 3</AttrName>
<AttrValue>test2</AttrValue>
</Row>
<Row Year="2001">
<AttrName ID="4">Doc 1 T2 AttrName 4</AttrName>
<AttrValue>test3</AttrValue>
</Row>
<Row Year="2002">
<AttrName ID="5">Doc 1 T2 AttrName 5</AttrName>
<AttrValue>test78</AttrValue>
</Row>
<Row Year="2003">
<AttrName ID="6">Doc 1 T2 AttrName 6</AttrName>
<AttrValue>test56</AttrValue>
</Row>
<Row Year="2004">
<AttrName ID="7">Doc 1 T2 AttrName 7</AttrName>
<AttrValue>test67</AttrValue>
</Row>
</Item>
</SubSection>
</Document>
<Document Title="Document Two" DocumentID="2">
<Section Title="Introduction" ID="2">
<Item Type="SimpleAttributeTable" TemplateNodeID="T3">
<Row>
<AttrName ID="1">
<b>Doc</b> 1 T1 AttrName 1
</AttrName>
<AttrValue>
<b>12</b>
</AttrValue>
</Row>
<Row>
<AttrName ID="2">Doc 1 T1 AttrName 2</AttrName>
<AttrValue><b>133</b></AttrValue>
</Row>
<Row Year="2001">
<AttrName ID="3">Doc 1 T1 AttrName 3</AttrName>
<AttrValue>145</AttrValue>
</Row>
<Row Year="2002">
<AttrName ID="4">Doc 1 T1 AttrName 4</AttrName>
<AttrValue>167</AttrValue>
</Row>
</Item>
<Item Type="QuarterlyAttributeTable" Title="Doc2 - Quarterly Attribute Table - 1" DisplayType="TableDisplayType" TemplateNodeID="13">
<Row>
<AttrName ID="81">X3</AttrName>
<AttrValue>Value of Year 1999 attr X Q1</AttrValue>
<AttrValue>Value of Year 1999 attr X Q2</AttrValue>
<AttrValue>Value of Year 1999 attr X Q3</AttrValue>
<AttrValue>Value of Year 1999 attr X Q4</AttrValue>

</Row>
<Row>
<AttrName ID="2">Y3</AttrName>
<AttrValue>Value of Year 1999 attr Y Q1</AttrValue>
<AttrValue>Value of Year 1999 attr Y Q2</AttrValue>
<AttrValue>Value of Year 1999 attr Y Q3</AttrValue>
<AttrValue>Value of Year 1999 attr Y Q4</AttrValue>

</Row>

<Row>
<AttrName ID="3">X4</AttrName>
<AttrValue>Value of Year 2000 attr X Q1</AttrValue>
<AttrValue>Value of Year 2000 attr X Q2</AttrValue>
<AttrValue>Value of Year 2000 attr X Q3</AttrValue>
<AttrValue>Value of Year 2000 attr X Q4</AttrValue>

</Row>
<Row>
<AttrName ID="4">Y4</AttrName>
<AttrValue>Value of Year 2000 attr Y Q1"</AttrValue>
<AttrValue>Value of Year 2000 attr Y Q2"</AttrValue>
<AttrValue>Value of Year 2000 attr Y Q3"</AttrValue>
<AttrValue>Value of Year 2000 attr Y Q4"</AttrValue>

</Row>
</Item>

<Item Type="AnnualAttributeTable" TemplateNodeID="T2">
<Row Year="1999">
<AttrName ID="1">Doc 2 T2 AttrName 1</AttrName>
<AttrValue>test067</AttrValue>
</Row>
<Row Year="2000">
<AttrName ID="2">Doc 2 T2 AttrName 2</AttrName>
<AttrValue>test166</AttrValue>
</Row>
<Row Year="2001">
<AttrName ID="3">Doc 2 T2 AttrName 3</AttrName>
<AttrValue>test672</AttrValue>
</Row>
<Row Year="2002">
<AttrName ID="4">Doc 2 T2 AttrName 4</AttrName>
<AttrValue>test63</AttrValue>
</Row>
<Row Year="2003">
<AttrName ID="5">Doc 2 T2 AttrName 5</AttrName>
<AttrValue>test668</AttrValue>
</Row>
<Row Year="2004">
<AttrName ID="6">Doc 2 T2 AttrName 6</AttrName>
<AttrValue>test55676</AttrValue>
</Row>
<Row Year="2005">
<AttrName ID="7">Doc 2 T2 AttrName 7</AttrName>
<AttrValue>test66577</AttrValue>
</Row>
</Item>
<SubSection Title="Introduction" ID="2"> 
<Item Type="AnnualAttributeTable" TemplateNodeID="T1">
<Row Year="1999">
<AttrName ID="1">Doc 2 Sub T1 AttrName 1</AttrName>
<AttrValue>test40</AttrValue>
</Row>
<Row>
<AttrName ID="2">Doc 2 Sub T1 AttrName 2</AttrName>
<AttrValue>test14</AttrValue>
</Row>
<Row>
<AttrName ID="3">Doc 2 Sub T1 AttrName 3</AttrName>
<AttrValue>test245</AttrValue>
</Row>
<Row>
<AttrName ID="4">Doc 2 Sub T1 AttrName 4</AttrName>
<AttrValue>test45</AttrValue>
</Row>
<Row>
<AttrName ID="5">Doc 2 Sub T1 AttrName 5</AttrName>
<AttrValue>test7458</AttrValue>
</Row>
<Row>
<AttrName ID="6">Doc 2 Sub T1 AttrName 6</AttrName>
<AttrValue>test545</AttrValue>
</Row>
<Row>
<AttrName ID="7">Doc 2 Sub T1 AttrName 7</AttrName>
<AttrValue>test6457</AttrValue>
</Row>
</Item>
</SubSection>
</Section>
</Document>
</ComparisonDocument>

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> 
<xsl         [img]http://www.javaranch.com/ubb/redface.gif[/img]utput method="html" indent="no"/> 
<xsl:key name="keyType" match="Item" use="@Type"/>
<xsl:key name="table" match="Item/Row" use="AttrName/@ID"/>
<xsl:key name="table1" match="Attr" use="@ID"/>
<xsl:key name="MatchID" match="View/ComparisonTable" use="@TemplateNodeID"/>
<xsl:template match="HTML | BODY | SPAN | B | UL | LI | P | BR | FONT | A | TABLE | TR | TD | IMG | CENTER | b | ul | li | p | br | font | a | table | tr | td | img | center | ecibgcolor">
<xsl:copy>
<xsl:copy-of select="@*" />
      <xsl:apply-templates />
    </xsl:copy>
</xsl:template>
<xsl:template match="eciColBgcolor | eciAlign" />
<xsl:template match="/">
<html>
<head>
<LINK REL="stylesheet" TYPE="text/css" HREF="document.css" title="STYLE"/>
</head>
<body>
<BR/><BR/>
<xsl:choose>
<xsl:when test="key('keyType', 'SimpleAttributeTable') or key('keyType', 'AnnualAttributeTable')">
<table align="center" border="1" cellspacing="0" cellpadding="4" width="800">
<tr>
<td>�</td>

<xsl:for-each select="//Document/@Title">
<td align="center" class="cssheader11">
<xsl:apply-templates select="." />
</td>
</xsl:for-each>

</tr>
<xsl:for-each select="//View/ComparisonTable">

<xsl:variable name="currentTableID" select="@TemplateNodeID"/>

<xsl:variable name="currentRow" select="key('table', Attribute/@ID)[../@TemplateNodeID=$currentTableID]"/>
<tr>
<td class="cssbody11">
<xsl:value-of select="$currentTableID"/><BR/>
<xsl:value-of select="$currentRow/AttrName"/><BR/>
</td>
</tr>

</xsl:when>
</xsl:choose>

</xsl:for-each>
</table>

</body>
</html> 
</xsl:template>
</xsl:stylesheet>

Thanks in advance
[This message has been edited by Tanya Rawat (edited September 05, 2001).]

Did you see how Paul cut 87% off of his electric heat bill with 82 watts of micro heaters?