Re: [xsl] Get to 2 max values and element names

[Michael Müller-Hillebrand <mmh@xxxxxxxxxxxxx>]

William,

you did not suggest how the different Modifier values will be specified, so I
made a guess. The solution (created with famous ;Kernow for Saxon+!) is not
very clever as I did not want to check out what XSLT 1 really can do. I have
commented out some debugging output and there are no node-set() function
included, but it worked with Kernow fine.

Check it out,

- Michael

<?xml version="1.0" encoding="UTF-8"?>
<xsl:transform xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
xmlns:xs="http://www.w3.org/2001/XMLSchema"; version="1.0"
exclude-result-prefixes="xs">
	<xsl:output indent="yes" />

	<xsl:variable name="mods">
		<mod nr="6">
			<Steve>1.2</Steve>
			<Helen>0.65</Helen>
			<Jack>0.89</Jack>
			<Petra>1.32</Petra>
		</mod>
	</xsl:variable>

	<xsl:template match="/">
		<out>
			<xsl:variable name="nr" select="/Data/Modifier" />
			<xsl:variable name="mod">
				<xsl:copy-of select="$mods/mod[@nr = $nr]" />
			</xsl:variable>
			<xsl:variable name="calc">
				<xsl:for-each select="/Data/List/*[number(.) &gt; 0]">
					<xsl:variable name="name" select="name(.)" />
					<xsl:if test="$mod/mod/*[name(.) = $name]">
						<xsl:element name="{name(.)}">
							<xsl:value-of select="number(.) * number($mod/mod/*[name(.) = $name])"
/>
						</xsl:element>
					</xsl:if>
				</xsl:for-each>
			</xsl:variable>
			<xsl:variable name="sort">
				<xsl:for-each select="$calc/*">
					<xsl:sort select="." data-type="number" order="descending" />
					<xsl:copy-of select="." />
				</xsl:for-each>
			</xsl:variable>
			<!-- xsl:copy-of select="$mod"/ -->
			<!-- xsl:copy-of select="$calc"/ -->
			<!-- xsl:copy-of select="$sort"/ -->
			<xsl:value-of select="concat('TopValue = ', $sort/*[1], '&#xA;TopName = ',
name($sort/*[1]), '&#xA;PenultValue = ', $sort/*[2], '&#xA;PenultName = ',
name($sort/*[2]))" />
		</out>
	</xsl:template>

</xsl:transform>

Am 11.05.2012 um 15:36 schrieb W Charlton:

>
> I have a peculiar problem. We have to extract the top 2 (modified) values
from some elements in a list and also get the element names. The xml is
something like:
>
> <Data>
>   <Modifier>6</Modifier>
>   <List>
>       <Julian>123</Julian>
>       <Steve>45654</Steve>
>       <Helen>98412</Helen>
>       <Jack>-50</Jack>
>       <Ruth>981</Ruth>
>       <Susan>8431</Susan>
>       <Trevor>354</Trevor>
>       <Petra>6257</Petra>
>       <Harold>25632</Harold>
>       <Mary>8695</Mary>
>   </List>
> </Data>
>
> Note: We know that sometimes Jacks (and only Jacks) value is negative, in
which case he is excluded from the calculation.
> It is also possible that any of the numbers are NULL in which case they are
also excluded or ignored.
>
> I need to do the following:
>
> Depending on the value of the Modifier (1-10) we have 4 variables.
> vSteveMod, vHelenMod, vJackMod and vPetraMod
> These vary depending on the value of the Modifier, there are 10 quartets of
values.
>
> We now need to calculate the modified values for Steve, Helen, Jack and
Petra (these 4 are chosen specifically for this test) dictated by the current
Modifier (6).
> So say that when the Modifier = 6, the 4 Modifying vars are:
> vSteveMod = 1.2
> vHelenMod = 0.65
> vJackMod = 0.89
> vPetraMod = 1.32
>
> We then multiply these *Mod vars by the related value, so:
> vSteveResult = 1.2 * 45654 = 54784.8
> vHelenResult = 0.65 * 98412 = 63967.8
> vJackResult = 0.89 * -50 = EXCLUDED
> vPetraResult = 1.32 * 6257 = 8259.24
>
> Finally we need to extract 4 values:
> The Top value and element name.
> The next (penultimate) highest value and also the element name.
>
> e.g. in this case:
>
> TopValue = 63967.8
> TopName = Helen
> PenultValue = 54784.8
> PenultName = Steve
>
> All using XSLT1
>
> William Charlton
> The yMonda team
> yMonda Limited
> w: www.ymonda.net
>
>

--
_______________________________________________________________
Michael M|ller-Hillebrand: Dokumentations-Technologie
Adobe Certified Expert, FrameMaker
Lvsungen und Training, FrameScript, XML/XSL, Unicode
Blog: http://cap-studio.de/ - Tel. +49 (9131) 28747