Ndtyjky

I am new to xsl. I understand that some similar questions have been asked, but I need help since I can't figure out what was wrong with my code. I have xml transactions file. I want to ,first, group by date, then sort each group of transactions by time

I have this xml

<History>

    <ShareLoanResults>

        <Account>123</Account>

        <PostingDt>20180718</PostingDt>

        <PostingTime>215642</PostingTime>

        <AmtLoan>000000000</AmtLoan>

        <AmtShare>000000001</AmtShare>

        <AmtInt>000000000</AmtInt>

        <Balance>000000487</Balance>

        <Description />

    </ShareLoanResults>

    <ShareLoanResults>

        <Account>123</Account>

        <PostingDt>20180719</PostingDt>

        <PostingTime>215650</PostingTime>

        <AmtLoan>000000000</AmtLoan>

        <AmtShare>000000003</AmtShare>

        <AmtInt>000000000</AmtInt>

        <Balance>000000494</Balance>

        <Description />

    </ShareLoanResults>

    <ShareLoanResults>

        <Account>123</Account>

        <PostingDt>20180719</PostingDt>

        <PostingTime>215640</PostingTime>

        <AmtLoan>000000000</AmtLoan>

        <AmtShare>000000002</AmtShare>

        <AmtInt>000000000</AmtInt>

        <Balance>000000489</Balance>

        <Description />

    </ShareLoanResults>

    <ShareLoanResults>

        <Account>123</Account>

        <PostingDt>20180717</PostingDt>

        <PostingTime>215641</PostingTime>

        <AmtLoan>000000000</AmtLoan>

        <AmtShare>000000004</AmtShare>

        <AmtInt>000000000</AmtInt>

        <Balance>000000486</Balance>

        <Description />

    </ShareLoanResults>

</History>

I am looking for this result

<History>

<ShareLoanResults>

    <Order>1</Order>

    <Account>123</Account>

    <PostingDt>20180717</PostingDt>

    <PostingTime>215641</PostingTime>

    <Amount>4</Amount>

</ShareLoanResults>

<ShareLoanResults>

    <Order>1</Order>

    <Account>123</Account>

    <PostingDt>20180718</PostingDt>

    <PostingTime>215642</PostingTime>

    <Amount>1</Amount>

</ShareLoanResults>

<ShareLoanResults>

    <Order>1</Order>

    <Account>123</Account>

    <PostingDt>20180719</PostingDt>

    <PostingTime>215640</PostingTime>

    <Amount>3</Amount>

</ShareLoanResults>

<ShareLoanResults>

    <Order>2</Order>

    <Account>123</Account>

    <PostingDt>20180719</PostingDt>

    <PostingTime>215650</PostingTime>

    <Amount>3</Amount>

</ShareLoanResults>

</History>

Here is my xsl

<xsl:stylesheet version='2.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'>

<xsl:output method="xml" omit-xml-declaration="no" />



<xsl:template match="/">      

<xsl:copy>

    <xsl:for-each-group select="History/ShareLoanResults" group-by="PostingDt">

            <xsl:for-each select="current-group()">

            <xsl:sort select="PostingTime" order="ascending"/>

                <ShareLoanResults>

                    <Order>

                        <xsl:value-of select="position()"/>

                    </Order>

                    <Account>

                        <xsl:value-of select="Account"/>

                    </Account>

                    <PostingDt>

                        <xsl:value-of select="PostingDt"/>

                    </PostingDt>    

                    <PostingTime>

                        <xsl:value-of select="PostingTime"/>

                    </PostingTime>  

                    <Amount>

                        <xsl:value-of select="format-number(AmtShare,'#.000000')"/>

                    </Amount>

                </ShareLoanResults>

            </xsl:for-each>  

    </xsl:for-each-group>

</xsl:copy>

</xsl:template>



</xsl:stylesheet>

However, I am getting exception: javax.xml.transform.TransformerException: Could not find function: current-group

If I remove the <xsl:for-each-group select="current-group()"> and its corresponding closed tag, I get empty result below

<?xml version="1.0" encoding="UTF-8" standalone="no"?>

<ShareLoanResults><Order/><Account/><PostingDt/><PostingTime/><Amount>NaN</Amount></ShareLoanResults>

Could someone please tell me what I did wrong and/or was missing?
Thanks!

As mentioned by our XSLT gurus, you do not need any grouping or even a 2.0 processor. Simply sort by date and time, and have Order node count following siblings with same date:

<xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'>

    <xsl:output method="xml" omit-xml-declaration="no" indent="yes" />

    <xsl:strip-space elements="*"/>



    <xsl:template match="/History">   

      <xsl:copy>   

        <xsl:apply-templates select="ShareLoanResults">

            <xsl:sort select="PostingDt"/>

            <xsl:sort select="PostingTime"/>

        </xsl:apply-templates>

      </xsl:copy>

    </xsl:template>



    <xsl:template match="ShareLoanResults">      

        <xsl:variable name="curr_dt" select="PostingDt"/>

        <xsl:copy>

            <Order>

                <xsl:value-of select="count(following-sibling::*[PostingDt=$curr_dt])+1"/>

            </Order>

            <Account>

                <xsl:value-of select="Account"/>

            </Account>

            <PostingDt>

                <xsl:value-of select="PostingDt"/>

            </PostingDt>    

            <PostingTime>

                <xsl:value-of select="PostingTime"/>

            </PostingTime>  

            <Amount>

                <xsl:value-of select="format-number(AmtShare,'#.000000')"/>

            </Amount>

        </xsl:copy>

    </xsl:template>

</xsl:stylesheet>

XSLT Demo