XSLT : generate csv from xml which has multiple occurences of tags complex scenario

CaseyLiam

New Member
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::P/D"/> <xsl:text>,</xsl:text> <xsl:value-of select="ancestor::P/E"/> <xsl:text> </xsl:text></xsl:for-each>\[/code\]Please suggest correct xslt
 
Back
Top