Sorting Help

[Energy]

I need help sorting XML file. Below is the XSLT, I am using. I am trying to sort the PIPTransaction based on Usage tag, UsagePurpose. If UsagePurpose="C ancel" transaction should be at the starting of the file and than rest of the transaction after UsagePurpose="C ancel" . Thanks In advance.

[code=xml]<?xml version="1.0"?>
<xsl:styleshe et xmlns:xsl="http ://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:pd="http://www.oeb.gov.on. ca" exclude-result-prefixes="pd">
<xsl:template name="Usage">
<xsl:apply-templates mode="copynode"/>
</xsl:template>
<xsl:template match="@*" mode="copynode" >
<xsl:copy>
<xsl:apply-templates select="@*" mode="copynode"/>
<xsl:apply-templates mode="copynode"/>
<xsl:for-each select="pd:Usag e">
<xsl:sort select="@UsageP urpose" order="descendi ng" data-type="text"/>
</xsl:for-each>
</xsl:copy>
</xsl:template>
<xsl:template match="*" mode="copynode" >
<!--xsl:element name="{local-name()}" namespace=""-->
<xsl:element name="{local-name()}">
<xsl:apply-templates select="@*" mode="copynode"/>
<xsl:apply-templates mode="copynode"/>
</xsl:element>
</xsl:template>
</xsl:stylesheet>[/code]

XML file

<?xml version="1.0" encoding="UTF-8"?>
<PIPEDocument CreationDate="2 007012507012812 5ES" DocumentReferen ceNumber="doc00 0006759814" Version="3.1" xsi:schemaLocat ion="http://www.oeb.gov.on. ca PIPEDocument.xs d" xmlns:xsi="http ://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.oeb.gov.on. ca">
<PIPTransacti on TransactionRefe renceNumber="00 0006759814">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759750">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>99709 5</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759835">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759845">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759857">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>99709 5</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759999">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006760024">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006760061">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006760064">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006760166">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006760186">
<Usage BillRequired="Y es" UsagePurpose="O riginal">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006760869">
<InvoiceSettlem entTotal BillPurpose="Or iginal">
<MarketParticip antInformation>
<CompanyName>ti es Ltd</CompanyName>
<GSTRegistratio nNumber>820586</GSTRegistration Number>
<MarketParticip antAccountNumbe r ParticipantType ="Distributor"> 02293594</MarketParticipa ntAccountNumber >
</MarketParticipa ntInformation>
</InvoiceSettleme ntTotal>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006760673">
<InvoiceSettlem entDetail BillPurpose="Or iginal" TransactionCros sReferenceNumbe r="000006760869 ">
<MarketParticip antInformation>
<CompanyName>ti es Ltd</CompanyName>
<GSTRegistratio nNumber>8671205 86</GSTRegistration Number>
<MarketParticip antAccountNumbe r ParticipantType ="Distributor"> 0293594</MarketParticipa ntAccountNumber >
</MarketParticipa ntInformation>
</InvoiceSettleme ntDetail>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006756662">
<NSLSDaily UnitOfMeasure=" kWh" Date="20070109" >
<Zone>
<NSLSEntry>
<Consumption>14 9444</Consumption>
<Price>3.06</Price>
</NSLSEntry>
</Zone>
</NSLSDaily>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759538">
<ApplicationAdv iceAccept OriginalTransac tionReferenceNu mber="702300007 00980" PIPTransactionT ype="InvoiceBil lReady">
<ConsumerInform ation>
<FullName>Sto re 26805</FullName>
</ConsumerInforma tion>
<AccountInforma tion>
<ConsumerAccoun tNumber ParticipantType ="Distributor"> 571720426700172 0</ConsumerAccount Number>
</AccountInformat ion>
</ApplicationAdvi ceAccept>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759632">
<DropRequest>
<DropInformatio n>
<Reason>Nonpaym ent By Customer</Reason>
</DropInformation >
</DropRequest>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759640">
<Usage OriginalTransac tionReferenceNu mber="000006121 188" BillRequired="Y es" UsagePurpose="C ancel">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 000659646">
<Usage OriginalTransac tionReferenceNu mber="000006989 02" BillRequired="Y es" UsagePurpose="C ancel">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759642">
<Usage OriginalTransac tionReferenceNu mber="000006238 274" BillRequired="Y es" UsagePurpose="C ancel">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759643">
<Usage OriginalTransac tionReferenceNu mber="000006359 096" BillRequired="Y es" UsagePurpose="C ancel">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759651">
<Usage OriginalTransac tionReferenceNu mber="000006358 797" BillRequired="Y es" UsagePurpose="C ancel">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759660">
<Usage OriginalTransac tionReferenceNu mber="000006626 224" BillRequired="Y es" UsagePurpose="C ancel">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759653">
<Usage OriginalTransac tionReferenceNu mber="000006237 816" BillRequired="Y es" UsagePurpose="C ancel">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
<PIPTransacti on TransactionRefe renceNumber="00 0006759662">
<Usage OriginalTransac tionReferenceNu mber="000006121 616" BillRequired="Y es" UsagePurpose="C ancel">
<ConsumerInform ation>
<FullName>o Ltd. Partnership</FullName>
</ConsumerInforma tion>
</Usage>
</PIPTransaction>
</PIPEDocument>

[dorinbogdan]

Hi,

Did you succeed to solve your problem?
If not, please let me know.
If yes, feel free to share it, to help other members with similar questions.

Thanks,
Dorin.