How to print full path from an Xml using Xsl

Gururaj CV · August 21st, 2015, 07:21 AM

Hello,

Below is the Xml.
<Dimension name="Product" >
<Member name="MAHierarchy1" />
<Member name="MAFolder3" >
<Member name="MAFolder4" >
<Member name="MAFolder5" >
<Member name="MAHierarchy2" />
<Member name="MAHierarchy3" />
<Member name="MAHierarchy4" />
<Member name="MAHierarchy5" />
<Member name="MAHierarchy6" />
<Member name="MAHierarchy7" />
</Member>
<Member name="MAFolder6" >
<Member name="MAHierarchy8" />
<Member name="MAHierarchy9" />
</Member>
</Member>
<Member name="MAFolder7" >
<Member name="MAFolder8" >
<Member name="MAHierarchy10" />
</Member>
<Member name="MAFolder9" >
<Member name="MAHierarchy11" />
<Member name="MAHierarchy12" />
<Member name="MAHierarchy13" />
</Member>
</Member>
</Member>
</Dimension>

Can any one tell me how to create fullpath like below by Xsl?

<Dimension name="Product" >
<Member name="MAHierarchy1" fullPath="Product" />
<Member name="MAFolder3" fullPath="Product">
<Member name="MAFolder4" fullPath="Product.MAFolder3">
<Member name="MAFolder5" fullPath="Product.MAFolder3.MAFolder4" >
<Member name="MAHierarchy2" fullPath="Product.MAFolder3.MAFolder4.MAFolder5"/>
<Member name="MAHierarchy3" fullPath="Product.MAFolder3.MAFolder4.MAFolder5"/>
<Member name="MAHierarchy4" fullPath="Product.MAFolder3.MAFolder4.MAFolder5"/>
<Member name="MAHierarchy5" fullPath="Product.MAFolder3.MAFolder4.MAFolder5"/>
<Member name="MAHierarchy6" fullPath="Product.MAFolder3.MAFolder4.MAFolder5"/>
<Member name="MAHierarchy7" fullPath="Product.MAFolder3.MAFolder4.MAFolder5"/>
</Member>
<Member name="MAFolder6" fullPath="Product.MAFolder3.MAFolder4">
<Member name="MAHierarchy8" fullPath="Product.MAFolder3.MAFolder4.MAFolder6"/>
<Member name="MAHierarchy9" fullPath="Product.MAFolder3.MAFolder4.MAFolder6"/>
</Member>
</Member>
<Member name="MAFolder7" fullPath="Product.MAFolder3">
<Member name="MAFolder8" fullPath="Product.MAFolder3.MAFolder7">
<Member name="MAHierarchy10" fullPath="Product.MAFolder3.MAFolder7.MAFolder8"/>
</Member>
<Member name="MAFolder9" fullPath="Product.MAFolder3.MAFolder7">
<Member name="MAHierarchy11" fullPath="Product.MAFolder3.MAFolder7.MAFolder9"/>
<Member name="MAHierarchy12" fullPath="Product.MAFolder3.MAFolder7.MAFolder9"/>
<Member name="MAHierarchy13" fullPath="Product.MAFolder3.MAFolder7.MAFolder9"/>
</Member>
</Member>
</Member>
</Dimension>

Martin Honnen · August 21st, 2015, 08:04 AM

Assuming an XSLT 2.0 processor like Saxon 9 or XmlPrime or Altova Raptor you can do it with

Code:

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
  xmlns:xs="http://www.w3.org/2001/XMLSchema"
  exclude-result-prefixes="xs"
  version="2.0">
  
<xsl:template match="@* | node()">
  <xsl:copy>
    <xsl:apply-templates select="@* | node()"/>
  </xsl:copy>
</xsl:template>

<xsl:template match="Member">
  <xsl:copy>
    <xsl:apply-templates select="@*"/>
    <xsl:attribute name="fullPath" select="ancestor::*/@name" separator="."/>
    <xsl:apply-templates/>
  </xsl:copy>
</xsl:template>

</xsl:stylesheet>

Gururaj CV · August 24th, 2015, 04:01 AM

Hi Martin, thanks for the code. I tried this but I am getting blank value like below. Please advice on this.

<?xml version="1.0"?>
<Dimension name="Product">
<Member name="MAHierarchy1" fullPath=""/>
<Member name="MAFolder3" fullPath="">
<Member name="MAFolder4" fullPath="">
<Member name="MAFolder5" fullPath="">
<Member name="MAHierarchy2" fullPath=""/>
<Member name="MAHierarchy3" fullPath=""/>
<Member name="MAHierarchy4" fullPath=""/>
<Member name="MAHierarchy5" fullPath=""/>
<Member name="MAHierarchy6" fullPath=""/>
<Member name="MAHierarchy7" fullPath=""/>
</Member>
<Member name="MAFolder6" fullPath="">
<Member name="MAHierarchy8" fullPath=""/>
<Member name="MAHierarchy9" fullPath=""/>
</Member>
</Member>
<Member name="MAFolder7" fullPath="">
<Member name="MAFolder8" fullPath="">
<Member name="MAHierarchy10" fullPath=""/>
</Member>
<Member name="MAFolder9" fullPath="">
<Member name="MAHierarchy11" fullPath=""/>
<Member name="MAHierarchy12" fullPath=""/>
<Member name="MAHierarchy13" fullPath=""/>
</Member>
</Member>
</Member>
</Dimension>

Martin Honnen · August 24th, 2015, 04:42 AM

See http://xsltransform.net/6qVRKxc, it works fine for me using an XSLT 2.0 processor like Saxon 9.

RacerBoy · August 27th, 2015, 10:10 AM

Thanks @Martin for your link here.