For this xml:\[code\] <G> <P> <A> <b>value b</b> <c>value c</c> </A> <A> <b>value b2</b> <c>value c2</c> </A> <D>value ew</D> <D>value e2</D> <E>value f</E> </P> <P> <A> <b>value bx</b> <c>value cx</c> </A> <A> <b>value b2x</b> <c>value c2x</c> </A> <D>value exw</D> <D>value ex2</D> <D>value ex2</D> <E>value fx</E> </P> </G>\[/code\]The tags like A and D can occur multiple times , the original xml on which I am working has large number of tags and many of them have multiple occurences.I have to genetrate output as :
value b value c value ew value f
value b value c value e2 value f
value b2 value c2 value ew value f
value b2 value c2 value e2 value f
value bx value cx value exw value fx
value bx value cx value ex2 value fx
value bx value cx value ex3 value fx
value b2x value c2x value exw value fx
value b2x value c2x value ex2 value fx
value b2x value c2x value ex3 value fx
This xslt generates correct output if A tag has multiple occurence ,but when other tags like D in above xml repeat this does not work.\[code\]<xsl:for-each select="//A"> <xsl:value-of select="b"/> <xsl:text>,</xsl:text> <xsl:value-of select="c"/> <xsl:text>,</xsl:text> <xsl:value-of select="ancestor:/D"/> <xsl:text>,</xsl:text> <xsl:value-of select="ancestor:/E"/> <xsl:text> </xsl:text></xsl:for-each>\[/code\]Please suggest correct xslt
value b value c value ew value f
value b value c value e2 value f
value b2 value c2 value ew value f
value b2 value c2 value e2 value f
value bx value cx value exw value fx
value bx value cx value ex2 value fx
value bx value cx value ex3 value fx
value b2x value c2x value exw value fx
value b2x value c2x value ex2 value fx
value b2x value c2x value ex3 value fx
This xslt generates correct output if A tag has multiple occurence ,but when other tags like D in above xml repeat this does not work.\[code\]<xsl:for-each select="//A"> <xsl:value-of select="b"/> <xsl:text>,</xsl:text> <xsl:value-of select="c"/> <xsl:text>,</xsl:text> <xsl:value-of select="ancestor:/D"/> <xsl:text>,</xsl:text> <xsl:value-of select="ancestor:/E"/> <xsl:text> </xsl:text></xsl:for-each>\[/code\]Please suggest correct xslt