Transformation for repeating nodes

palety · June 21st, 2010, 05:07 PM

How can I trasnform using XSL 1.0

<Region>
<RecType1><Amt> 100 </Amt></RecType1>
<RecType2><Name>XXX</Name></RecType2>
<RecType1><Amt> 200 </Amt></RecType1>
<RecType2><Name>YYY</Name></RecType2>
<RecType1><Amt> 300 </Amt></RecType1>
<RecType2><Name>ZZZ</Name></RecType2>
</Region>

TO

<Region>
<Payment><Amt>100</Amt><Name>XXX</Name></Payment>
<Payment><Amt>200</Amt><Name>YYY</Name></Payment>
<Payment><Amt>300</Amt><Name>ZZZ</Name></Payment>
</Region>

I appreciate your help.

Thank you,
Praveen

mhkay · June 21st, 2010, 05:18 PM

Code:

<xsl:for-each select="RecType1">
  <Payment>
     <xsl:copy-of select="Amt"/>
     <xsl:copy-of select="following-sibling::RecType2[1]/Name"/>
  </Payment>
</xsl:for-each>