[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] few nodes are missing ??
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
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|