Hi, I have below xml and I want to have two tables with sorted data like first tabel should be sorted with term years and second table should be sorted with term years and claim type. please help me first table Term 1 (2020-09-20 to 2021-09-20) Term 2 (2019-09-20 to 2020-09-20) Term 3 (2018-09-20 to 2019-09-20) No of claims 21 8 0 Claims Amount 4500000 340000 0 Second table Term 1 (2020-09-20 to 2021-09-20) Term 2 (2019-09-20 to 2020-09-20) Term 3 (2018-09-20 to 2019-09-20) Coverage Number of claims Claims Amount Number of claims Claims Amount Number of claims Claims Amount Loss 7 70000 4 40000 0 0 Theft 2 200000 2 100000 0 0 Fire 12 180000 2 200000 0 0 XML UP 2020-09-20 2021-09-20 LOSS 2 1 3 10000 20000 30000 FIRE 5 5 10 50000 30000 80000 THEFT 1 1 2 150000 50000 200000 MP 2020-09-20 2021-09-20 LOSS 2 2 4 20000 20000 40000 FIRE 1 1 2 50000 50000 100000 MP 2019-09-20 2020-09-20 LOSS 2 2 4 20000 20000 40000 FIRE 1 1 2 50000 50000 100000 THEFT 1 1 2 150000 50000 200000

Hi Ani, Please check this link. https://www.javatpoint.com/xslt-xsl-sort-element

Answer

Multiple Sorting in xsl

Ani

1.2k

Hi,

I have below xml and I want to have two tables with sorted data like first tabel should be sorted with term years and second table should be sorted with term years and claim type. please help me
first table

	Term 1 (2020-09-20 to 2021-09-20)	Term 2 (2019-09-20 to 2020-09-20)	Term 3 (2018-09-20 to 2019-09-20)
No of claims	21	8	0
Claims Amount	4500000	340000	0

Second table

	Term 1 (2020-09-20 to 2021-09-20)		Term 2 (2019-09-20 to 2020-09-20)		Term 3 (2018-09-20 to 2019-09-20)
Coverage	Number of claims	Claims Amount	Number of claims	Claims Amount	Number of claims	Claims Amount
Loss	7	70000	4	40000	0	0
Theft	2	200000	2	100000	0	0
Fire	12	180000	2	200000	0	0

XML

<Data>
    <StateDetails>
        <ClaimDetails>
            <State>UP</State>
            <EffectiveDate>2020-09-20</EffectiveDate>
            <ExpirationDate>2021-09-20</ExpirationDate>
            <Claims id="c7059429FF5044F5F9E72F0D366693D24">
                <Type>LOSS</Type>
                <ClaimsPersonal>2</ClaimsPersonal>
                <ClaimsBusiness>1</ClaimsBusiness>
                <TotalClaims>3</TotalClaims>
                <ClaimsPersonalAmount>10000</ClaimsPersonalAmount>
                <ClaimsBusinessAmount>20000</ClaimsBusinessAmount>
                <ClaimsAmount>30000</ClaimsAmount>
            </Claims>
            <Claims id="xyz59429FF5677F5F9E72F0D366693C00">
                <Type>FIRE</Type>
                <ClaimsPersonal>5</ClaimsPersonal>
                <ClaimsBusiness>5</ClaimsBusiness>
                <TotalClaims>10</TotalClaims>
                <ClaimsPersonalAmount>50000</ClaimsPersonalAmount>
                <ClaimsBusinessAmount>30000</ClaimsBusinessAmount>
                <ClaimsAmount>80000</ClaimsAmount>
            </Claims>
            <Claims id="xyz77629FF5677F5F9E72F0D366693E12">
                <Type>THEFT</Type>
                <ClaimsPersonal>1</ClaimsPersonal>
                <ClaimsBusiness>1</ClaimsBusiness>
                <TotalClaims>2</TotalClaims>
                <ClaimsPersonalAmount>150000</ClaimsPersonalAmount>
                <ClaimsBusinessAmount>50000</ClaimsBusinessAmount>
                <ClaimsAmount>200000</ClaimsAmount>
            </Claims>
        </ClaimDetails>
        <ClaimDetails>
            <State>MP</State>
            <EffectiveDate>2020-09-20</EffectiveDate>
            <ExpirationDate>2021-09-20</ExpirationDate>
            <Claims id="c7059429FF5044F5F9E72F0D366693D24">
                <Type>LOSS</Type>
                <ClaimsPersonal>2</ClaimsPersonal>
                <ClaimsBusiness>2</ClaimsBusiness>
                <TotalClaims>4</TotalClaims>
                <ClaimsPersonalAmount>20000</ClaimsPersonalAmount>
                <ClaimsBusinessAmount>20000</ClaimsBusinessAmount>
                <ClaimsAmount>40000</ClaimsAmount>
            </Claims>
            <Claims id="xyz59429FF5677F5F9E72F0D366693C00">
                <Type>FIRE</Type>
                <ClaimsPersonal>1</ClaimsPersonal>
                <ClaimsBusiness>1</ClaimsBusiness>
                <TotalClaims>2</TotalClaims>
                <ClaimsPersonalAmount>50000</ClaimsPersonalAmount>
                <ClaimsBusinessAmount>50000</ClaimsBusinessAmount>
                <ClaimsAmount>100000</ClaimsAmount>
            </Claims>
        </ClaimDetails>
        <ClaimDetails>
            <State>MP</State>
            <EffectiveDate>2019-09-20</EffectiveDate>
            <ExpirationDate>2020-09-20</ExpirationDate>
            <Claims id="c7059429FF5044F5F9E72F0D3644493324">
                <Type>LOSS</Type>
                <ClaimsPersonal>2</ClaimsPersonal>
                <ClaimsBusiness>2</ClaimsBusiness>
                <TotalClaims>4</TotalClaims>
                <ClaimsPersonalAmount>20000</ClaimsPersonalAmount>
                <ClaimsBusinessAmount>20000</ClaimsBusinessAmount>
                <ClaimsAmount>40000</ClaimsAmount>
            </Claims>
            <Claims id="xyz59429FF5677F5F9E72F0D366693X11">
                <Type>FIRE</Type>
                <ClaimsPersonal>1</ClaimsPersonal>
                <ClaimsBusiness>1</ClaimsBusiness>
                <TotalClaims>2</TotalClaims>
                <ClaimsPersonalAmount>50000</ClaimsPersonalAmount>
                <ClaimsBusinessAmount>50000</ClaimsBusinessAmount>
                <ClaimsAmount>100000</ClaimsAmount>
            </Claims>
            <Claims id="xyz77629FF5677F5F9E72F0D36669SD12">
                <Type>THEFT</Type>
                <ClaimsPersonal>1</ClaimsPersonal>
                <ClaimsBusiness>1</ClaimsBusiness>
                <TotalClaims>2</TotalClaims>
                <ClaimsPersonalAmount>150000</ClaimsPersonalAmount>
                <ClaimsBusinessAmount>50000</ClaimsBusinessAmount>
                <ClaimsAmount>200000</ClaimsAmount>
            </Claims>
        </ClaimDetails>
    </StateDetails>
</Data>