Grouping into a hierarchy

Play the video

Subject: Grouping into a hierarchy
From: Tim <timlhunt@xxxxxxxxxxxxxx>
Date: Tue, 11 Dec 2007 12:49:02 -0500

Hi. I have a newbie question. I have been able to extract data from two tables, into a work area like below. The data is below with a stlesheet to try to merge them, but I get all the detail.

<?xml version="1.0" encoding="UTF-8"?>
<WorkData>
   <Headers>
       <Header>
           <PO_NBR>138513</PO_NBR>
           <PROC_IND>N</PROC_IND>
       </Header>
       <Header>
           <PO_NBR>138522</PO_NBR>
           <PROC_IND>N</PROC_IND>
       </Header>
   </Headers>

   <Detail>
       <LineItem>
           <PO_NBR>138513</PO_NBR>
           <LINE_ITEM_NBR>1</LINE_ITEM_NBR>
           <BG_ID>VL 81268</BG_ID>
       </LineItem>
       <LineItem>
           <PO_NBR>138513</PO_NBR>
           <LINE_ITEM_NBR>2</LINE_ITEM_NBR>
           <BG_ID>VL 81200</BG_ID>
       </LineItem>
       <LineItem>
           <PO_NBR>138522</PO_NBR>
           <LINE_ITEM_NBR>1</LINE_ITEM_NBR>
           <BG_ID>VL 81265</BG_ID>
       </LineItem>
   </Detail>
</WorkData>

<!-- expected Merged hierarchy output-->
<WorkData>
   <Orders>
       <Order>
           <hdr>
               <PO_NBR>138513</PO_NBR>
               <PROC_IND>N</PROC_IND>
           </hdr>
           <LineItems>
               <LineItem>
                   <PO_NBR>138513</PO_NBR>
                   <LINE_ITEM_NBR>1</LINE_ITEM_NBR>
                   <BG_ID>VL 81268</BG_ID>
               </LineItem>
               <LineItem>
                   <PO_NBR>138513</PO_NBR>
                   <LINE_ITEM_NBR>2</LINE_ITEM_NBR>
                   <BG_ID>VL 81200</BG_ID>
               </LineItem>
           </LineItems>
       </Order>
       <Order>
           <hdr>
               <PO_NBR>138522</PO_NBR>
               <PROC_IND>N</PROC_IND>
           </hdr>
           <LineItems>
               <LineItem>
                   <PO_NBR>138522</PO_NBR>
                   <LINE_ITEM_NBR>1</LINE_ITEM_NBR>
                   <BG_ID>VL 81265</BG_ID>
               </LineItem>
           </LineItems>
       </Order>
   </Orders>
</WorkData>

<?xml version="1.0"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/WorkData/Headers/Header"> <xsl:for-each select="/WorkData/Headers/Header"> <xsl:value-of select="."/> <xsl:for-each select="/WorkData/Detail/LineItem/*"> <xsl:value-of select="."/> <xsl:text>
</xsl:text> </xsl:for-each> <xsl:text>-+-
</xsl:text> </xsl:for-each> </xsl:template> </xsl:stylesheet>

Current Thread
Grouping into a hierarchy Tim - 11 Dec 2007 17:49:40 -0000 <= Spencer Tickner - 11 Dec 2007 19:30:35 -0000 Spencer Tickner - 11 Dec 2007 19:29:40 -0000

<- Previous	Index	Next ->
[Announce] Stylus Studio 2008, Stylus Studio	Thread	Re: Grouping into a hierarchy, Spencer Tickner
[Announce] Stylus Studio 2008, Stylus Studio	Date	Re: Grouping into a hierarchy, Spencer Tickner
	Month

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

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >