Re: [xsl] How to generate multiple rows based on sub element

abhilash k wrote:

> We are using XSLT 1.0 and have to map XML to a CSV file, the input looks like this 
> <Message> 
>  <Work>Contract</Work> 
>  <Timesheet>Approved</Timesheet> 
>  <Days> 
>         <Mon>8</Mon> 
>         <Tues>7</Tues> 
>         <Fri>9</Fri> 
>  </Days> 
> </Message> 
> In the output depending on the days worked we need to generate multiple rows. ie the XSLT logic for all other fields will remain the same (Work, Timesheet etc), the logic will change only for field 'Days'...any inputs on how to accomplish this in XSLT
> Expected Output: 
> ------------------------- 
> Work,   Timesheet,      Days,  Hours 
> Contract, Approved,     Mon,   8 
> Contract, Approved,     Tues,  7 
> Contract, Approved,     Fri,     9 
This stylesheet should do:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
  version="1.0">

  <xsl:output method="text"/>

  <xsl:param name="sep" select="', '"/>
  <xsl:param name="lf" select="'&#13;&#10;'"/>

  <xsl:template match="/">
    <xsl:value-of select="concat('Work', $sep, 'Timesheet', $sep, 
'Days', $sep, 'Hours', $lf)"/>
    <xsl:for-each select="Message/Days/*">
      <xsl:value-of select="concat(../../Work, $sep, ../../Timesheet, 
$sep, name(), $sep, ., $lf)"/>
    </xsl:for-each>
  </xsl:template>

</xsl:stylesheet>
--

        Martin Honnen
        http://msmvps.com/blogs/martin_honnen/

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--