Cart
|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Can I group in three levels?
 I have problems to generate the desired output of an XML using XSL. I want to group in three levels Unfortunately your data didn't reflect very much of these groupings, so I created a larger test set in addition to your set. This is my XSL, that doesn't work You don't always have to use the key() function ... an answer below uses variables, which I find much easier for multi-level sorting. Looking through the code, you'll see a lot of symmetry of each level using only a subset of the variable from the previous level. It gives the precise structure answer you quoted (except of course for indentation). I hope this helps. ................ Ken
<xsl:output indent="yes"/> <xsl:template match="/">
<xsl:variable name="rows" select="/ROWSET/ROW"/>
<xsl:for-each select="$rows">
<xsl:sort select="ID"/>
<xsl:if test="generate-id(.)=generate-id($rows[ID=current()/ID and
NUMBER=current()/NUMBER])">
<ID><xsl:value-of select="ID"/></ID>
<NUM><xsl:value-of select="NUMBER"/></NUM>
<xsl:variable name="idnums" select="$rows[ID=current()/ID and
NUMBER=current()/NUMBER]"/>
<xsl:for-each select="$idnums">
<xsl:sort select="PHONE"/>
<xsl:if test="generate-id(.)=
generate-id($idnums[PHONE=current()/PHONE])">
<PHONE_DATA>
<PHONE><xsl:value-of select="PHONE"/></PHONE>
<xsl:variable name="phones"
select="$idnums[PHONE=current()/PHONE]"/>
<xsl:for-each select="$phones">
<xsl:if test="generate-id(.)=
generate-id($phones[ACT=current()/ACT])">
<ACT_DATA>
<ACT><xsl:value-of select="ACT"/></ACT>
</ACT_DATA>
</xsl:if>
</xsl:for-each>
</PHONE_DATA>
</xsl:if>
</xsl:for-each>
</xsl:if>
</xsl:for-each></xsl:template> </xsl:stylesheet> T:\ftemp>saxon felix.xml felix.xsl
<?xml version="1.0" encoding="utf-8"?>
<ID>27835</ID>
<NUM>29715</NUM>
<PHONE_DATA>
<PHONE>09876</PHONE>
<ACT_DATA>
<ACT>ACT34</ACT>
</ACT_DATA>
</PHONE_DATA>
<ID>27835</ID>
<NUM>29716</NUM>
<PHONE_DATA>
<PHONE>3333333</PHONE>
<ACT_DATA>
<ACT>ACT23</ACT>
</ACT_DATA>
<ACT_DATA>
<ACT>ACT111</ACT>
</ACT_DATA>
</PHONE_DATA>
<PHONE_DATA>
<PHONE>62784</PHONE>
<ACT_DATA>
<ACT>ACT87</ACT>
</ACT_DATA>
</PHONE_DATA>
T:\ftemp>type felix2.xml
<?xml version="1.0" encoding="UTF-8"?>
<ROWSET>
<ROW>
<ID>27835</ID>
<NUMBER>29715</NUMBER>
<PHONE>09876</PHONE>
<ACT>ACT34</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>62784</PHONE>
<ACT>ACT87</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>3333333</PHONE>
<ACT>ACT23</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>3333333</PHONE>
<ACT>ACT111</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29715</NUMBER>
<PHONE>09876</PHONE>
<ACT>ACT34</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29715</NUMBER>
<PHONE>09877</PHONE>
<ACT>ACT34</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>62784</PHONE>
<ACT>ACT87</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>3333333</PHONE>
<ACT>ACT23</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>3333333</PHONE>
<ACT>ACT111</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29715</NUMBER>
<PHONE>09876</PHONE>
<ACT>ACT35</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>62784</PHONE>
<ACT>ACT87</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>3333333</PHONE>
<ACT>ACT23</ACT>
</ROW>
<ROW>
<ID>27835</ID>
<NUMBER>29716</NUMBER>
<PHONE>3333333</PHONE>
<ACT>ACT112</ACT>
</ROW>
</ROWSET>T:\ftemp>saxon felix2.xml felix.xsl
<?xml version="1.0" encoding="utf-8"?>
<ID>27835</ID>
<NUM>29715</NUM>
<PHONE_DATA>
<PHONE>09876</PHONE>
<ACT_DATA>
<ACT>ACT34</ACT>
</ACT_DATA>
<ACT_DATA>
<ACT>ACT35</ACT>
</ACT_DATA>
</PHONE_DATA>
<PHONE_DATA>
<PHONE>09877</PHONE>
<ACT_DATA>
<ACT>ACT34</ACT>
</ACT_DATA>
</PHONE_DATA>
<ID>27835</ID>
<NUM>29716</NUM>
<PHONE_DATA>
<PHONE>3333333</PHONE>
<ACT_DATA>
<ACT>ACT23</ACT>
</ACT_DATA>
<ACT_DATA>
<ACT>ACT111</ACT>
</ACT_DATA>
<ACT_DATA>
<ACT>ACT112</ACT>
</ACT_DATA>
</PHONE_DATA>
<PHONE_DATA>
<PHONE>62784</PHONE>
<ACT_DATA>
<ACT>ACT87</ACT>
</ACT_DATA>
</PHONE_DATA>
T:\ftemp>rem Done!
G. Ken Holman mailto:gkholman@xxxxxxxxxxxxxxxxxxxx Crane Softwrights Ltd. http://www.CraneSoftwrights.com/s/ Box 266, Kars, Ontario CANADA K0A-2E0 +1(613)489-0999 (F:-0995) ISBN 0-13-065196-6 Definitive XSLT and XPath ISBN 0-13-140374-5 Definitive XSL-FO ISBN 1-894049-08-X Practical Transformation Using XSLT and XPath ISBN 1-894049-10-1 Practical Formatting Using XSL-FO Next conference training: 2002-12-08,03-03,06 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
|
