Source format:
<d1 name="a1">
   <d2 name="b1">
       <d3 name="c1"/>
   </d2>
   <d2 name="b2">
       <d3 name="c2"/>
   </d2>
</d1>
<d1 name="a2">
   <d2 name="b3">
       <d3 name="c3"/>
       <d3 name="c4"/>
   </d2>
</d1>


Output format:
<row d1="a1" d2="b1" d3="c1" />
<row d1="a1" d2="b2" d3="c2" />
<row d1="a2" d2="b3" d3="c3" />
<row d1="a2" d2="b3" d3="c4" />


The twist is that the source xml is created dynamic and any tag can be used to idetify a new row to be created in output xml.In above example you can see that first part of source xml the d2 tag was used to as seperation to create a new row and in second part of source xml he tag d3 act as deciding factor to create a new row.
As the source xml is dynamic any tag from d1,d2,d3,d(n)...... can be deciding factor for creation of new row in output xml.

Is it possible using XSLT...
if yes can you help we with some good examples approaching this issue.

Regards,
Aayam

<xsl:template match="/">
  <xsl:apply-templates select="//*[not(*)]"/>
</xsl:template>

<xsl:template match="*">
  <row>
    <xsl:for-each select="ancestor-or-self::*">
      <xsl:attribute name="{name()}">
        <xsl:value-of select="@name"/>
      </xsl:attribute>
    </xsl:for-each>
  </row>
</xsl:template>

Not tested

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

Hi kay,

where to refer to understand the concepts of
ancestor-or-self::* and so...with some examples

Raj

You can refer Michael Kay's "XSLT 2.0 and XPath 2.0 Programmer's Reference".

In the above input xml, the root element was not specified. To discard the root element attribute from the result try

 <xsl:template match="/">
  <xsl:apply-templates select="//*[not(*)]"/>
</xsl:template>

<xsl:template match="*">
  <row>
    <xsl:for-each select="(ancestor-or-self::*) except (ancestor::root-element-name)">
      <xsl:attribute name="{name()}">
        <xsl:value-of select="@name"/>
      </xsl:attribute>
    </xsl:for-each>
  </row>
</xsl:template>


------
Rummy

>where to refer to understand the concepts of
ancestor-or-self::* and so...with some examples

Page 609-613 of my book, XSLT 2.0 and XPath 2.0 Programmer's Reference, 4thy edition.



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