Hi,

I have some data being returned like this :

[u]Column1 | Column2 | Column 3 | Column 4</u>
 ABC | DEF | GHI | JKL
 123 | 456 | 789 | 101

When i write out the information i want to loop through each column and write out the column name. Is this possible ?

Thanks

What does your input look like (in XML) and what do you want the output to look like?

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

It looks like this :
<row>
  <PartnerCode>Partner1</PartnerCode>
  <Column1>50%</Column1>
  <Column2>20%</Column2>
  <Column3>30%</Column3>
</row>
<row>
  <PartnerCode>Partner2</PartnerCode>
  <Column1>25%</Column1>
  <Column2>30%</Column2>
  <Column3>45%</Column3>
</row>

and i want write it out like this :

        Partner1 Partner2
Column1 50% 25%
Column2 20% 30%
Column3 30% 45%

Thanks

I'm assuming you want HTML output though you still haven't actually said...

Something like this:

<table>
  <tr>
    <td/>
    <xsl:for-each select="row">
     <td><xsl:value-of select="PartnerCode"/></td>
    </xsl:for-each>
  </tr>

  <xsl:for-each select="row[1]/*[not(self::PartnerCode)]">
  <tr>
    <xsl:variable name="p" select="position()"/>
    <td><xsl:value-of select="name()"/></td>
    <xsl:for-each select="../../row/*[position()=$p]">
      <td><xsl:value-of select="."/></td>
    </xsl:for-each>
  </tr>
  </xsl:for-each>
</table>

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

Thanks very much Micheal!

That work 99% perfectly :)

The only question i have is I see the code at the top which skips PartnerCode when writing out the first column, but it still writes out the data for partner code so it appears like this

        Partner1 Partner2
Column1 Partner1 Partner1
Column2 50% 25%
Column3 20% 30%

I presume I need to exclude that field from this for each ;

    <xsl:for-each select="../../row/*[position()=$p]">
      <td><xsl:value-of select="."/></td>
    </xsl:for-each>

can you help me out with the syntax ?

thanks

Sorry about that. Change to

<xsl:variable name="p" select="position()+1"/>

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

thanks, works like a charm!

you the man!