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 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Sandeep ChauhanSubject: How to achieve this transformation using XSLT Mapper?
Author: Sandeep Chauhan
Date: 26 Oct 2012 05:24 AM
Hi,

I am evaluating XSLT Mapper of Stylus Studio for some work here at Microsoft. I got stuck at the following transformation:

Input XML (attached) contains a list of teams with their information: team name, matches played and runs scored. Record of runs scored is kept in 3 different categories: Overall, Home and Away.

My output schema (attachment) is just a list of teams with their name.

I want to transform the input XML such that the output contains teams sorted by runs scored in "Home" category. How do I achieve this using XSLT mapper.

I am attaching the screenshot of what I could do best. However, in the sort port there seems to be no way to specify that I want to sort on values where the category name is "Home". Moreover, there also does not seem to be a graphical way of specifying in the sort port the order of sorting (ascending/descending) I want.

Can you please tell whether it's even possible to do this visually using XSLT mapper and if yes, how.

Thanks,
Sandeep


ImageWhat_I_Could_Do_Best.png


DocumentInputFile(1).xml


UnknownOutputSchema(1).xsd

Posttop
Ivan PedruzziSubject: How to achieve this transformation using XSLT Mapper?
Author: Ivan Pedruzzi
Date: 26 Oct 2012 04:47 PM

Hi Sandeep,

You need a predicate in order to filter the node-set
<xsl:for-each select="TeamsStats/TeamInfo[Runs/Category/@name='Home']">

The XSLT mapping tool does not expose predicates as visual instructions

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 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-2016 All Rights Reserved.