[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Grouping into a hierarchy
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> <!-- My XSL so far gets all the detail, rather than associating detail with the correct header portion: --> <?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>
|
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
|