Subject: [xsl] few nodes are missing ?? From: Dipesh Khakhkhar <dkhakhkh@xxxxxxxxxxxxxxx> Date: Wed, 3 Sep 2003 18:07:01 -0400 |
Hi, I am trying to solve one problem. I am presenting the mock example of my input and output. XML === <?xml version="1.0" encoding="UTF-8"?> <Root Att1="val1" Att2="val2"> <Node1 Node1Att="Nval1" Node2Att="Nval2"> <CLASS Table="Firsttable"> <Row> <Column ColName="ValOfColName1">Colvalue1</Column> <Column ColName="ValOfColName2">Colvalue2</Column> <Column ColName="ValOfColName3">Colvalue3</Column> </Row> <Row> <Column ColName="ValOfColName2">Colvalue2</Column> <Column ColName="ValOfColName4">Colvalue4</Column> </Row> </CLASS> </Node1> <Node1 Node1Att="val1" Node2Att="val2"> <CLASS Table="Firsttable"> <Row> <Column ColName="ValOfColName1">Colvalue1</Column> <Column ColName="ValOfColName2">Colvalue2</Column> <Column ColName="ValOfColName3">Colvalue3</Column> <Column ColName="ValOfColName5">Colvalue5</Column> </Row> <Row> <Column ColName="ValOfColName4">Colvalue4</Column> <Column ColName="ValOfColName6">Colvalue6</Column> </Row> </CLASS> </Node1> </Root> --------------------------------------------------------------------- I need to have ouput like this.First I ouput column name as column header and then I have to get the data below the column header. I have used "`" as a seperator. Desired Output -------------- RootID`Att1`Att2`RootID`Node1ID`Node1Att`Node2Att`Node1ID`FirstTableID`ValOfCo lName1`ValOfColName2`ValOfColName3`ValOfColName4`ValOfColName5`ValOfColName6 GeneratedIDForRoot`val`val2`GeneratedIdForRoot`GeneratedIDForNode1`Nval1`Nval2 `GeneratedIDForNode1`GeneratedFirstTableID`Colvalue1`Colvalue2`Colvalue3``` ``````````Colvalue2``Colvalue4`` ```GeneratedIdForRoot`GeneratedIDForNode1`Nval1`Nval2`GeneratedIDForNode1`Gene ratedFirstTableID`Colvalue1`Colvalue2`Colvalue3``Colvalue5` ````````````Colvalue4``Colvalue6 --------------------------------------------------------------------- Current XSL =========== <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="text"/> <!-- Getting Root node with maximum attributes --> <xsl:variable name="mostattForRootNode"> <xsl:for-each select="//Root"> <xsl:sort select="count(attribute::*)" order="descending" data-type="number"/> <xsl:if test="position()=1"> <xsl:value-of select="generate-id()"/> </xsl:if> </xsl:for-each> </xsl:variable> <xsl:variable name="maxAttRoot-node" select="//node()[generate-id() = $mostattForRootNode]"/> <!-- Getting Node1 node with maximum attributes --> <xsl:variable name="mostattForNode1"> <xsl:for-each select="//Node1"> <xsl:sort select="count(attribute::*)" order="descending" data-type="number"/> <xsl:if test="position()=1"> <xsl:value-of select="generate-id()"/> </xsl:if> </xsl:for-each> </xsl:variable> <xsl:variable name="maxAttNode1-node" select="//node()[generate-id() = $mostattForNode1]"/> <!-- Getting FirstTable node with maximum childnodes i.e. having maximum columns--> <xsl:variable name="mostattFirsttable"> <xsl:for-each select="//Root/Node1/CLASS[normalize-space(@Table)='Firsttable']/Row"> <xsl:sort select="count(Column)" data-type="number" order="descending"/> <xsl:if test="position()=1"> <xsl:value-of select="generate-id(.)"/> </xsl:if> </xsl:for-each> </xsl:variable> <xsl:variable name="maxattFirsttable-node" select="//node()[generate-id() = $mostattFirsttable]"/> <!-- Outputting Column Header first and Then Data --> <xsl:template match="/"> <!-- Printing header for Root --> <xsl:text>RootID`</xsl:text> <xsl:for-each select="$maxAttRoot-node/@*"> <xsl:value-of select="name(.)"/> <xsl:if test="position()!=last()">`</xsl:if> </xsl:for-each> <!-- Printing header for Node1 --> <xsl:text>`RootID`Node1ID`</xsl:text> <xsl:for-each select="$maxAttNode1-node/@*"> <xsl:value-of select="name(.)"/> <xsl:if test="position()!=last()">`</xsl:if> </xsl:for-each> <!-- Printing header for Firsttable i.e. Class node with attribute="First table" --> <xsl:for-each select="$maxattFirsttable-node"> <xsl:text>`Node1ID`FirstTableID`</xsl:text> <xsl:for-each select="Column/@ColName"> <xsl:value-of select="."/> <xsl:if test="position()!=last()">`</xsl:if> </xsl:for-each> </xsl:for-each> <xsl:text> </xsl:text> <!-- Now putting data data below the Column Headers --> <xsl:apply-templates select="/Root"/> </xsl:template> <xsl:template match="Root"> <xsl:value-of select="generate-id(.)"/><xsl:text>`</xsl:text> <xsl:variable name="r" select="."/> <xsl:for-each select="$maxAttRoot-node"> <xsl:for-each select="@*"> <xsl:choose> <xsl:when test="$r/@*[name()=name(current())]"> <xsl:value-of select="."/> <xsl:if test="position()!=last()">`</xsl:if> </xsl:when> <xsl:otherwise>`</xsl:otherwise> </xsl:choose> </xsl:for-each> <!--<xsl:text> </xsl:text> --> </xsl:for-each> <xsl:apply-templates select="Node1"/> </xsl:template> <!-- Template for resouce Type --> <xsl:template match="Node1">`<xsl:value-of select="generate-id(..)"/>`<xsl:value-of select="generate-id(.)"/><xsl:text>`</xsl:text> <xsl:variable name="r" select="."/> <xsl:for-each select="$maxAttNode1-node"> <xsl:for-each select="@*"> <xsl:choose> <xsl:when test="$r/@*[name()=name(current())]"> <xsl:value-of select="."/> <xsl:if test="position()!=last()">`</xsl:if> </xsl:when> <xsl:otherwise>`</xsl:otherwise> </xsl:choose> </xsl:for-each> <!--<xsl:text> </xsl:text> --> </xsl:for-each> <xsl:apply-templates select="CLASS"/> <!-- I will count the attributes of parent node and dynamically generate the seperators --> <xsl:if test="not (position()=last())"> <xsl:text> </xsl:text> <xsl:call-template name="do-quotes"> <xsl:with-param name="count" select="count($maxAttRoot-node/@*) "/> </xsl:call-template> </xsl:if> </xsl:template> <!--Temaplate for Class --> <xsl:template match="CLASS"> <xsl:choose> <!-- When Table is Firsttable --> <xsl:when test="normalize-space(@Table)='Firsttable'">`<xsl:for-each select="Row"><xsl:variable name="r" select="."/><xsl:value-of select="generate-id(../..)"/>`<xsl:value-of select="generate-id(.)"/><xsl:text>`</xsl:text> <xsl:for-each select="$maxattFirsttable-node/Column"> <xsl:value-of select="normalize-space($r/Column[@ColName=current()/@ColName])"/> <xsl:if test="position()!=last()">`</xsl:if> </xsl:for-each> <xsl:if test="not (position()=last())"> <xsl:text> </xsl:text> <xsl:call-template name="do-quotes"> <xsl:with-param name="count" select="count($maxAttRoot-node/@*) + count($maxAttNode1-node/@*) + 3"/> </xsl:call-template> </xsl:if> </xsl:for-each> </xsl:when> </xsl:choose> </xsl:template> <!-- RECURSIVE TEMPLATE TO OUTPUT DELIMTER i.e " `" --> <xsl:template name="do-quotes"> <xsl:param name="count" select="0"/> <xsl:if test="$count"> <xsl:text>`</xsl:text> <xsl:call-template name="do-quotes"> <xsl:with-param name="count" select="$count - 1"/> </xsl:call-template> </xsl:if> </xsl:template> </xsl:stylesheet> -------------------------------------------------------------------- In the above xsl I am findng first the Class node with name="Firsttable" and finding a row node with maximum "column" nodes. If i follow this approach I miss few columns which are not trapped when i found a node (Row) having maximum column nodes. But I need the header which can give me all the column names. How do i get all the nodes and then correspondingly get the data ? Thanks in the anticipation that this time i will get some suggestion how to tackle this problem. My earlier two emails qouted the same problem but it was very length. This is comparatively simple and not that length. Eagerly waiting for reply. Regards, Dipesh XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
RE: [xsl] strange for-each/list beh, Américo Albuquerque | Thread | RE: [xsl] few nodes are missing ??, Américo Albuquerque |
Re: [xsl] strange for-each/list beh, David Carlisle | Date | Re: [xsl] to find all childrens for, Wendell Piez |
Month |