• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Need to write XSL for this XML

 
Raja Mario
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I m new to XSL and XSLT. I am using XSLT 1.0 and trying to write the XSLT for the following XML. The output should be, disticnt "PaymentMethod" and the maximum "Amount" in that Payment method.

Required Output:

MasterCard 100
Visa 10
Diners Club 89

XML:

<?xml version="1.0" encoding="utf-8"?>
<Report Name="Payment Detail" Version="1.0" MerchantID="gbp">
<Batches>
<Batch BatchID="1234" BatchDate="2007-06-03">
<Requests>
<Request RequestID="555" MerchantReferenceNumber="1234">
<PaymentMethod>Visa</PaymentMethod>
<CurrencyCode>GBP</CurrencyCode>
<Amount>10.00</Amount>
<Application>bill</Application>

</Request>
<Request RequestID="3456" MerchantReferenceNumber="555">
<PaymentMethod>Visa</PaymentMethod>
<CurrencyCode>GBP</CurrencyCode>
<Amount>10.00</Amount>
<Application>bill</Application>

</Request>
<Request RequestID="44" MerchantReferenceNumber="7655">
<PaymentMethod>MasterCard</PaymentMethod>
<CurrencyCode>GBP</CurrencyCode>
<Amount>83.00</Amount>
<Application>bill</Application>

</Request>
<Request RequestID="55" MerchantReferenceNumber="5678">
<PaymentMethod>MasterCard</PaymentMethod>
<CurrencyCode>GBP</CurrencyCode>
<Amount>82.00</Amount>
<Application>bill</Application>

</Request>
<Request RequestID="1234" MerchantReferenceNumber="67">
<PaymentMethod>Visa</PaymentMethod>
<CurrencyCode>USD</CurrencyCode>
<Amount>81.00</Amount>
<Application>bill</Application>

</Request>
<Request RequestID="2439599466520008401927"
MerchantReferenceNumber="45">
<PaymentMethod>Diners Club</PaymentMethod>
<CurrencyCode>USD</CurrencyCode>
<Amount>89.00</Amount>
<Application>bill</Application>

</Request>
<Request RequestID="2439600359220008402433"
MerchantReferenceNumber="3364613CJY22222CV4BY">
<PaymentMethod>Visa</PaymentMethod>
<CurrencyCode>GBP</CurrencyCode>
<Amount>10.00</Amount>
<Application>bill</Application>
</Request>
<Request RequestID="44" MerchantReferenceNumber="7655">
<PaymentMethod>MasterCard</PaymentMethod>
<CurrencyCode>GBP</CurrencyCode>
<Amount>100.00</Amount>
<Application>bill</Application>
</Request>
</Requests>
</Batch>
</Batches>
</Report>



I tried to use the grouping concept and it is not working. Could anyone help me on this?

Thanks
Raja
 
Paul Clapham
Sheriff
Pie
Posts: 20971
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Well, you know we don't write code for people here. But it seems to me that grouping wouldn't be a bad approach. Sorting based on the "Amount" element and choosing the last value out of the sort would also work.
 
Raja Mario
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

Thanks for the reply. Actually your reply induced me to do some research on this and finally I got my output. :)

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:param name="lb" select="' '" />
<xsl:param name="sep" select="' '" />
<xsl:output method="text" />
<xsl:key name="by-payment" match="Request" use="PaymentMethod" />

<xsl:template match="/">
<xsl:apply-templates select="Report/Batches/Batch/Requests/Request[generate-id() = generate-id(key('by-payment', PaymentMethod)[1])]" mode="card">
<xsl:sort select="PaymentMethod" data-type='text' order='descending'/>
</xsl:apply-templates>
</xsl:template>

<xsl:template match="Request" mode="card">
<xsl:variable name="group" select="key('by-payment', PaymentMethod)" />
<xsl:for-each select="$group">
<xsl:sort select="sum(Amount)" order="descending" data-type='number'/>
<xsl:if test="position() = 1">
<xsl:value-of select="concat(PaymentMethod, $sep, sum(Amount), $sep, CurrencyCode, $sep, $lb)" />
</xsl:if>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

I would like to study more on XSLT transfermation. Could you tell me the good site which has tutorials with samples? [Samples will give the best undestanding]

Thanks
Raja
 
Paul Clapham
Sheriff
Pie
Posts: 20971
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That's not bad at all. Grouping isn't an easy thing to do in XSLT 1.0, but it looks like you have it working.

I learned XSLT by reading Michael Kay's book. But there are tutorials on the web, some good, some bad. I don't recommend the ones at w3schools because they just rehash the syntax. That means they don't mention important concepts which aren't described by syntax, like the built-in template rule for example. And they choose examples designed to explain the specific elements of syntax, which isn't the right way to choose examples.

(It's like help documents which answer questions like "What does the F7 key do" when your question is more like "How do I get to the next customer record".)

Anyway have a look at Jeni Tennison's tutorials.
 
Raja Mario
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Paul, Thank you very much
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic