[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] RE: converting flat xml data into heirarchy structure
> -----Original Message----- > From: David Buddrige > Hi David, > I have a source document that is currently being > generated from an Oracle database - it is effectively > a table dump in xml format of the "scope" table.. It > has the following structure. > <snip /> I think, the best way to go about this is something like: <?xml version="1.0" encoding="UTF-8" ?> <xsl:template match="scopes"> <!-- apply templates on all scope elements with parent_id '0' --> <xsl:apply-templates select="scope[@parent_id='0']" /> </xsl:template> <xsl:template match="scope"> <!-- create a var to hold the current scope's id --> <xsl:variable name="vId" select="@id" /> <xsl:copy> <!-- copy attributes --> <xsl:apply-templates select="@*" /> <scopes> <!-- now apply templates on all scope elements with parent_id equal to current id --> <xsl:apply-templates select="//scope[@parent_id=$vId]" /> </scopes> </xsl:template> Caution: this solution would create empty 'scopes' elements when there are no 'scope' elements that satisfy the condition '@parent_id=$vId'. You could test for this with an xsl:if first. Hope this helps! Cheers, Andreas XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|