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
Arvind KushwahaPosted Nov 1, 2021, 11:32 AM