|
|
 next
|
  Subject: XSL: Key (not matches)
Author: James Delaney
Date: 25 Aug 2009 12:53 PM
|
Hello all,
I'm running some keys to give me matching results of IDs that have repeated presence, then to calcuate some of their elements.
While I can match keys to documents, I can not get a list of those IDs that did not match up. Here's a code snip:
<xsl:key name="test" match="Census/Fall2008/Student[Classification='trad undergrad' and @AdmitTerm='Fall Semester 2008']/SAT1[@type='Verbal']" use="../@Id"/>
<?xml version="1.0"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:fo="http://www.w3.org/1999/XSL/Format">
<xsl:template match="Census">
<html>
<body>
<h3> Orginial SAT Verbal Avg. Score</h3>
<xsl:variable name="Org_Sat_Sum">
<xsl:value-of select="format-number(sum(Fall2008/Student[Classification='trad undergrad' and @AdmitTerm='Fall Semester 2008']/SAT1[@type='Verbal']/Score),'###.##')"/>
</xsl:variable>
<xsl:variable name="Org_Sat_Count">
<xsl:value-of select="format-number(count(Fall2008/Student[Classification='trad undergrad' and @AdmitTerm='Fall Semester 2008']/SAT1[@type='Verbal']/Score),'###.##')"/>
</xsl:variable>
Verbal Sum: <xsl:value-of select="$Org_Sat_Sum"/><br/>
Verbal Count: <xsl:value-of select="$Org_Sat_Count"/><br/>
Avg. Verbal Score: <xsl:value-of select="format-number(($Org_Sat_Sum div $Org_Sat_Count),'###.##')"/> <br/><br/>
<h3> Returning SAT Verbal Avg. Score</h3>
<xsl:variable name="Returning_Sat_Sum">
<xsl:value-of select="sum(key('test', ./Spring2009/Student/@Id))"/>
</xsl:variable>
<xsl:variable name="Returning_Sat_Count">
<xsl:value-of select="count(key('test', ./Spring2009/Student/@Id))"/>
</xsl:variable>
<br/>
Verbal Sum: <xsl:value-of select="$Returning_Sat_Sum"/>
<br/>
Verbal Count: <xsl:value-of select="$Returning_Sat_Count"/>
<br/>
Avg. Verbal Score: <xsl:value-of select="format-number(($Returning_Sat_Sum div $Returning_Sat_Count),'###.##')"/> <br/><br/>
<br/>
</body>
</html>
</xsl:template>
</xsl:stylesheet>
-------------------------------------
This is working correctly as it properly applies the key to presence in the other Spring2009 path. 10 records are NOT matched, as they were only present in Fall2008, and not Spring2009. These not matched records are important to know and I would like to perform similar calculations on them.
How can I perform a "reverse key" or apply a method similar? I'm thinking the answer might be within apply-template usage, but can't get it down correctly. Here's an example of at least the thought process behind what I am trying to achieve:
<xsl:value-of select="count(key('test', not(./Spring2009/Student/@Id)))"/>
Thanks!
|
 top
|
Subject: XSL: Key (not matches)
Author: James Delaney
Date: 16 Sep 2009 07:17 PM
Originally Posted: 16 Sep 2009 07:14 PM
|
Sure!
Here's a key:
<xsl:key name="TRADUG_F2008_Cohort_Verbal1" match="Census/Fall2008/Student[Classification='trad undergrad' and @AdmitTerm='Fall Semester 2008']/SAT1[@type='Verbal']" use="../@Id"/>
This key captures all students who fit into this specific Xpath condition (SAT1 type of Verbal, fall admit, and trad undergrad) within the Fall2008 tree.
I then apply this key to the Spring2009 tree:
<xsl:value-of select="sum(key('TRADUG_F2008_Cohort_Verbal1', ./Spring2009/Student[Classification='trad undergrad']/@Id))"/>
This returns to me their total sum of SAT scores, which I then average with the same value-of, but a count, instead of a sum for an average.
However, this only tells me data of students who were in Fall 2008 (my key) and those that are still in Spring 2009 (my value of).
But it doesn't tell me who was NOT matched from the original Fall 2008 Key in Spring 2009 tree. This is information that I need.
--------------------------
Here's an example:
XML file:
<Census>
<Fall2008>
<Student ID='1'>A</Student>
<Classification>trad undergrad</Classification>
<Student ID='2'>A</Student>
<Classification>trad undergrad</Classification>
<Student ID='3'>B</Student>
<Student ID='4'>C</Student>
</Fall2008>
<Spring2009>
<Student ID='1'>A</Student>
<Classification>trad undergrad</Classification>
<Student ID='3'>B</Student>
<Student ID='4'>C</Student>
<Student ID='5'>A</Student>
</Spring2009>
</Census>
XSL code:
<xsl:key name="Fall08_A_Only" match="Census/Fall2008/Student[Classification='trad undergrad']" use="@ID"/>
<xsl:value-of select="sum(key('Fall08_A_Only', ./Spring2009/Student[Classification='trad undergrad']/@ID))"/>
Doing this key, and this matchup will only match in Spring2009 the: <Student ID='1'>A<Student>
and not the
<Student ID='2'>A</Student>
The student A, with an ID of 2 has left the school. He's gone. But I want to know his data. They Fall_08 Key put his ID in memory while searching fall 09 for his presence, but when he's not found, he's not returned (correctly). But I would love to see those that are NOT matched as well, by using the key itself to determine the population that I can perform an output on.
Pretty much I am trying to find characteristics of students who return, as well as those that don't return. This has to be done by unique student ID's as students will come and go randomly throughout their life here. This is why I can't do a backwards key (from spring to fall) as new students might have skipped a semester.
Does this make sense? :)
Thanks again for all your help as always Alberto. This has been a critical resource in my XSLT/XML learning.
>Hi James,
>I am not sure to understand
>your requirements; could you
>explain better which students
>you are interested in finding
>out?
>
>Thanks,
>Alberto
|
|
|
|
