XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XSLT Help and Discussion » XSLT Math operations help
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
- XSLT Help and Discussion (7625)
-> + how to insert un return in the... (2)
-> + String in a range (5)
-> + To identify the right edition (4)
-> + Flow Control Feature (2)
-> + calling nested external functi... (3)
-> + Replacing commas with a blank (6)
-> + Grouping very urgent . (2)
-> + xsl node number (3)
-> + Wordml intelligence (6)
-> + Preview and backmapping for wo... (5)
-> + XSLT - find line numbers of di... (2)
-> + The last five bytes of a varia... (7)
-> + simple problem but i'm a bit t... (3)
-> + H plz help me (2)
-> + XSLT : Very Urgent Requirement (7)
-> + comparing two xml files (3)
-> + Support for xsl created from w... (4)
-> + Wildcard Param (3)
-> + XSLT OutOfMemoryError (3)
-> + How can I output the filename ... (7)
-> + How do I strip out a comma ast... (8)
-> + xslt current-dateTime() not re... (2)
-> + Exceed the maximum recursion d... (8)
-> + Saxon9 "java.net.ConnectExcept... (2)
-> - Help Required (1)
-> + XSLT Help to get value from Up... (2)
-> + Date Functions (5)
-> + Need to unescape < and > (2)
-> + No Topic (2)
-> + Problem with handling multiple... (3)
-> + Question XPath expression (dis... (2)
-> + New user, basic question (2)
-> + Serializing XML to a string wi... (2)
-> + Node already has a control li... (2)
-> + Trying to access the position ... (5)
-> + XSLT Help (2)
-> + XSLT, Microsoft Access, and re... (4)
-> + saxon:assign usage problem. (5)
-> + Help with XSLT mapping require... (4)
-> + Muenchian Grouping problem (6)
-> + Automatic postprocessing (2)
-> + Problem Setting Variable (3)
-> - Problem Setting Variable (1)
-> + Looping question (14)
-> + Attribute Centeric XML from Re... (2)
-> + How do I do this ? (2)
-> + Accessing an attribute based o... (3)
-> + help needed - using saxon thro... (2)
-> + Grouping Problem still (6)
-> + Use XSL-FO to create tables fr... (6)
-> + taking out a child and (6)
-> + Yet another problem (3)
-> + using XSL-FO to convert PDF (4)
-> + Preventing namespace declarati... (2)
-> + Small problem during conversio... (4)
-> + Problems removing namespaces (2)
-> + Grouping/Following question (4)
-> + Transforming XML into another ... (3)
-> + Help Needes (3)
-> - Help needed! (1)
-> + Conv of DSML Format to XML for... (2)
-> - Regd, entering text in the t... (1)
-> + displaying all the text around... (4)
-> + inserting values into empty ta... (5)
-> + How to get rid of xmlns="" att... (3)
-> + XSLT How to include the '<' sy... (2)
-> - HELP: Functional XSLT Implemen... (1)
-> - Cannot find a matching 1-argum... (1)
-> + XSLT a:? (2)
-> + Attribute Value Concatenation (2)
-> - Why is the WYSIWYG xslt editor... (1)
-> + WebService Call Error: Ref ele... (4)
-> + How to replace value of a fiel... (2)
-> + Schema Validation Problems (3)
-> + Reusing a prior valid value in... (5)
-> + Clutching at straws! (2)
-> + Adding a number to a for each ... (2)
-> + Transform Name Value pairs int... (4)
-> + Transform the XML Scheme with ... (2)
-> + create XML drop down lists (2)
-> + error during stylesheet tutori... (3)
-> + Modify the value in a element ... (2)
-> + Call to extension function fai... (2)
-> + Convert XML Schema to XML - Mi... (2)
-> + How to calculate maximun RowCo... (3)
-> + Help with using not(preceding:... (5)
-> - Please Help me on this XML to ... (1)
-> + Paasing Parameter Values From ... (6)
-> + XSLT Transformation w/ namespa... (3)
-> + For-each select and parameter ... (3)
-> + Using < (less than) operator (5)
-> + Inserting carriage return (spe... (3)
-> + Inserting carriage return (spe... (2)
-> + Help with SerializerTrace erro... (8)
-> + xml to x3d (5)
-> + Exiting processing loop early (2)
-> + Easy way to Convert One source... (3)
-> + XSLT Editor tab missing from D... (2)
-> + Writing strings of characters ... (4)
-> + Adding the content of an eleme... (3)
-- Previous [601-620] [621-640] [641-660] Next
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
educated idiotSubject: XSLT Math operations help
Author: educated idiot
Date: 10 Aug 2004 11:00 PM
Suppose I have an XML file that looks like this:
<A>
<VAL id="001">2</VAL>
<VAL id="233">4</VAL>
<VAL id="466">8</VAL>
</A>
<B>
<VAL id="001">2</VAL>
<VAL id="233">1</VAL>
<VAL id="466">4</VAL>
</B>

Is it possible to use XSLT to divide the first val in A by the first val
in B, and so on? The id attribute is not known at design-time, however:
- the first node is always divided by the first node in the other group, and so on
- the id attributes of these elements always match
- the id attributes in each of the two groups are unique

The desired output in this example would be:
<OUTPUT>
<OUT>1</OUT>
<OUT>4</OUT>
<OUT>2</OUT>
</OUTPUT>

Anyone have any ideas if and how this can be accomplished?

Any help would be much appreciated!
Postnext
Ivan PedruzziSubject: XSLT Math operations help
Author: Ivan Pedruzzi
Date: 10 Aug 2004 11:44 PM
You must have a root nodein your input document, i called root:

<?xml version="1.0"?>
<root>
<A>
<VAL id="001">2</VAL>
<VAL id="233">4</VAL>
<VAL id="466">8</VAL>
</A>
<B>
<VAL id="001">2</VAL>
<VAL id="233">1</VAL>
<VAL id="466">4</VAL>
</B>
</root>

then you can do something like that

<?xml version='1.0'?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:key name="B" match="root/B/VAL" use="@id"/>

<xsl:template match="/">
<OUTPUT>
<xsl:apply-templates select="root/A"/>
</OUTPUT>
</xsl:template>

<xsl:template match="text()"/>

<xsl:template match="VAL">
<OUT><xsl:value-of select=". div key('B',@id)"/></OUT>
</xsl:template>

</xsl:stylesheet>

Postnext
educated idiotSubject: XSLT Math operations help
Author: educated idiot
Date: 11 Aug 2004 11:12 PM
Thank you! I was not familiar with the <xml:key /> syntax. It works like
a charm.

Any suggestions on how to handle an extension to this problem? :
<root>
<A>
<VAL id="001">2</VAL>
<VAL id="233">4</VAL>
<VAL id="466">8</VAL>
</A>
<B>
<VAL id="001">2</VAL>
<VAL id="233">1</VAL>
<VAL id="466">4</VAL>
</B>
</root>

Now I would like to output the value of the first element in A divided by
the AVERAGE of the first two elements in B, and so on. Here is the desired
output:

<OUTPUT>
<OUT>0.667</OUT> <-- 2 / (2+1)
<OUT>0.8</OUT> <-- 4 / (1+4)
<OUT>-</OUT> <-- unable to compute
</OUTPUT>

I can't see a way to do this in XSLT, but I don't have much experience with the language.

Any ideas with this one?

Thanks again. Your help was much appreciated.
Postnext
Ivan PedruzziSubject: XSLT Math operations help
Author: Ivan Pedruzzi
Date: 12 Aug 2004 12:40 AM
I am not sure if you meant AVERANGE or SUM, but the following does what you described.

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:key name="B" match="root/B/VAL" use="@id"/>
<xsl:key name="A" match="root/A/VAL" use="@id"/>

<xsl:template match="/">
<OUTPUT>
<xsl:apply-templates select="root/A"/>
</OUTPUT>
</xsl:template>

<xsl:template match="text()"/>

<xsl:template match="VAL">
<xsl:for-each select="key('B',@id)">
<OUT>
<xsl:choose>
<xsl:when test="following-sibling::*[1]">
<xsl:value-of select="format-number(key('A',@id) div (. + following-sibling::*[1]), '###.###')"/>
</xsl:when>
<xsl:otherwise>-</xsl:otherwise>
</xsl:choose>
</OUT>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

Ivan

Postnext
educated idiotSubject: XSLT Math operations help
Author: educated idiot
Date: 12 Aug 2004 09:42 PM
Thank you once again.

Another extension to this problem. I was using the following-sibling notation
to retrieve the next sibling from ONE element. Now I would like to retrieve
another element with this same id from another node. I cannot seem to figure
out how to retrieve the value of the id attribute from this "next-sibling" node
so that I can pass it into a key() function (or whatever that syntax is referred to as).

A new XML file:
<root>
<A>
<VAL id="001">2</VAL>
<VAL id="233">4</VAL>
<VAL id="466">8</VAL>
</A>
<B>
<VAL id="001">2</VAL>
<VAL id="233">1</VAL>
<VAL id="466">4</VAL>
</B>
<C>
<VAL id="001">6</VAL>
<VAL id="233">7</VAL>
<VAL id="466">8</VAL>
</C>
</root>

For example, suppose I would like to divide the first element in A by the
sum of the 2nd elements in B and C. [ 2 / ( 1 + 7 ) ] I would then continue
in a loop as before -- divide the second element in A by the sum of the 3rd
elements in B and C.

I imagine this shouldn't be difficult using the building blocks you have already
shown me, but I can't seem to figure it out.

Thanks once again for your help.
Postnext
educated idiotSubject: XSLT Math operations help
Author: educated idiot
Date: 21 Aug 2004 12:14 PM
Is this not possible?

To summarize in case I wasn't clear:
Given an element, is it possible to retrieve its next sibling AND an
element in another node with the same id attribute, so that a math operation
can be performed on the two values?

If anyone has a lot of experience with XSL and thinks this is impossible,
I'd appreciate the opinion so that I can move on and look for a workaround.
This SEEMS like it should be possible, but with my lack of experience I can't
seem to figure it out.

Thanks once again for all the help.
Postnext
Ivan PedruzziSubject: XSLT Math operations help
Author: Ivan Pedruzzi
Date: 22 Aug 2004 06:03 PM
<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:key name="C" match="root/C/VAL" use="@id"/>
<xsl:key name="B" match="root/B/VAL" use="@id"/>
<xsl:key name="A" match="root/A/VAL" use="@id"/>

<xsl:template match="/">
<OUTPUT>
<xsl:apply-templates select="root/A"/>
</OUTPUT>
</xsl:template>

<xsl:template match="text()"/>

<xsl:template match="VAL">
<OUT>
<xsl:choose>
<xsl:when test="key('B',@id) and key('C',@id)">
<xsl:value-of select="format-number(. div (key('B',@id) + key('C',@id)), '###.###')"/>
</xsl:when>
<xsl:otherwise>-</xsl:otherwise>
</xsl:choose>
</OUT>
</xsl:template>
</xsl:stylesheet>

Posttop
Ivan PedruzziSubject: XSLT Math operations help
Author: Ivan Pedruzzi
Date: 25 Aug 2004 10:42 PM
The previous solution was obviously incorrect
Hopefully this was does what you want.

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="xml" indent="yes"/>
<xsl:key name="C" match="root/C/VAL" use="@id"/>
<xsl:key name="B" match="root/B/VAL" use="@id"/>

<xsl:template match="/">
<OUTPUT>
<xsl:apply-templates select="root/A"/>
</OUTPUT>
</xsl:template>

<xsl:template match="text()"/>

<xsl:template match="VAL">
<OUT>

<xsl:variable name="B">
<xsl:for-each select="key('B',@id)">
<xsl:value-of select="number(following-sibling::VAL[1])"/>
</xsl:for-each>
</xsl:variable>

<xsl:variable name="C">
<xsl:for-each select="key('C',@id)">
<xsl:value-of select="number(following-sibling::VAL[1])"/>
</xsl:for-each>
</xsl:variable>

<xsl:choose>
<xsl:when test="$B!='NaN' and $C!='NaN'">
<xsl:value-of select="format-number(. div ($B + $C), '###.###')"/>
</xsl:when>
<xsl:otherwise>-</xsl:otherwise>
</xsl:choose>
</OUT>
</xsl:template>
</xsl:stylesheet>

   
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-2016 All Rights Reserved.