XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
James DelaneySubject: 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!

Postnext
Alberto MassariSubject: XSL: Key (not matches)
Author: Alberto Massari
Date: 02 Sep 2009 12:25 PM
Hi James,
you can try building a key for

<xsl:key name="test2" match="Census/Spring2009/Student" use="@Id"/>

and then doing a

<xsl:value-of select="count(./Fall2008/Student[key('test2', @Id)=''])"/>

Alberto

Postnext
James DelaneySubject: XSL: Key (not matches)
Author: James Delaney
Date: 15 Sep 2009 12:59 PM
Hi Alberto,

As always, thanks for your help.

I went down this road earlier, however the list from Spring09 may include student ID's that have skipped a semester. Therefore their progression would not include the keyed semester. It would catch a lot of the key's "not matched", but not exactly.

Do you know of any other way that would give me the specific "not found in key"? Just as a template filter?


Best, James




>Hi James,
>you can try building a key for
>
><xsl:key name="test2"
>match="Census/Spring2009/Stude
>nt" use="@Id"/>
>
>and then doing a
>
><xsl:value-of
>select="count(./Fall2008/Stude
>nt[key('test2',
>@Id)=''])"/>
>
>Alberto

Postnext
Alberto MassariSubject: XSL: Key (not matches)
Author: Alberto Massari
Date: 16 Sep 2009 03:07 AM
Hi James,
I am not sure to understand your requirements; could you explain better which students you are interested in finding out?

Thanks,
Alberto

Posttop
James DelaneySubject: 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

 
Topic Page 1 2 3 4 5 6 7 8 9 Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2011 All Rights Reserved.