Subject: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.