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[(_at_)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