I’m struggling to perform the multilevel grouping in the following XML but not able to find
from where to start.
the following xml has airavailability as the root node and it contains airavailabilityreply.
airavailabilityreply contains various flightsegments with segmentoutgoing value either true or false
now this is the segmentoutgoing that decides whether the flight is towards the destination or a return flight.
now one destination flightsegment set can have different return flights that are returned in different availability
replies
now I just want to display the available flight segments towards the destination and available return flights
for the same segment i.e there may be one flight to destination and 12-13 options of returning flight.
i want to display the number of flights available and below that the available return flights.
W
0
320.92
377.69
USD
true
DL
4377
ABY
ATL
09/28/2004 10:10 AM
09/28/2004 11:02 AM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
954
ATL
LGA
09/28/2004 12:30 PM
09/28/2004 2:39 PM
U
738
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
297
LGA
ATL
09/29/2004 9:00 AM
09/29/2004 11:35 AM
U
738
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4389
ATL
ABY
09/29/2004 12:23 PM
09/29/2004 1:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
1
320.92
377.69
USD
true
DL
4377
ABY
ATL
09/28/2004 10:10 AM
09/28/2004 11:02 AM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
954
ATL
LGA
09/28/2004 12:30 PM
09/28/2004 2:39 PM
U
738
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
705
LGA
ATL
09/29/2004 8:00 AM
09/29/2004 10:33 AM
U
763
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4389
ATL
ABY
09/29/2004 12:23 PM
09/29/2004 1:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
2
320.92
377.69
USD
true
DL
4389
ABY
ATL
09/28/2004 1:50 PM
09/28/2004 2:52 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
980
ATL
LGA
09/28/2004 3:30 PM
09/28/2004 5:48 PM
U
757
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
297
LGA
ATL
09/29/2004 9:00 AM
09/29/2004 11:35 AM
U
738
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4389
ATL
ABY
09/29/2004 12:23 PM
09/29/2004 1:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
3
320.92
377.69
USD
true
DL
4154
ABY
ATL
09/28/2004 4:22 PM
09/28/2004 5:22 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
1204
ATL
LGA
09/28/2004 6:30 PM
09/28/2004 8:54 PM
U
763
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
1472
LGA
ATL
09/29/2004 10:00 AM
09/29/2004 12:27 PM
U
M80
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4154
ATL
ABY
09/29/2004 3:01 PM
09/29/2004 3:50 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
4
320.92
377.69
USD
true
DL
4377
ABY
ATL
09/28/2004 10:10 AM
09/28/2004 11:02 AM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
954
ATL
LGA
09/28/2004 12:30 PM
09/28/2004 2:39 PM
U
738
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
1431
LGA
ATL
09/29/2004 5:00 PM
09/29/2004 7:35 PM
U
M80
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
5
320.92
377.69
USD
true
DL
4154
ABY
ATL
09/28/2004 4:22 PM
09/28/2004 5:22 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
1204
ATL
LGA
09/28/2004 6:30 PM
09/28/2004 8:54 PM
U
763
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
615
LGA
ATL
09/29/2004 11:00 AM
09/29/2004 1:28 PM
U
763
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4154
ATL
ABY
09/29/2004 3:01 PM
09/29/2004 3:50 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
6
320.92
377.69
USD
true
DL
4377
ABY
ATL
09/28/2004 10:10 AM
09/28/2004 11:02 AM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
954
ATL
LGA
09/28/2004 12:30 PM
09/28/2004 2:39 PM
U
738
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
581
LGA
ATL
09/29/2004 6:00 PM
09/29/2004 8:35 PM
U
763
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
7
320.92
377.69
USD
true
DL
4154
ABY
ATL
09/28/2004 4:22 PM
09/28/2004 5:22 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
1204
ATL
LGA
09/28/2004 6:30 PM
09/28/2004 8:54 PM
U
763
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
1089
LGA
ATL
09/29/2004 12:00 PM
09/29/2004 2:25 PM
U
764
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4154
ATL
ABY
09/29/2004 3:01 PM
09/29/2004 3:50 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
8
320.92
377.69
USD
true
DL
4389
ABY
ATL
09/28/2004 1:50 PM
09/28/2004 2:52 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
980
ATL
LGA
09/28/2004 3:30 PM
09/28/2004 5:48 PM
U
757
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
237
LGA
ATL
09/29/2004 3:00 PM
09/29/2004 5:35 PM
U
757
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
9
320.92
377.69
USD
true
DL
4389
ABY
ATL
09/28/2004 1:50 PM
09/28/2004 2:52 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
980
ATL
LGA
09/28/2004 3:30 PM
09/28/2004 5:48 PM
U
757
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
1431
LGA
ATL
09/29/2004 5:00 PM
09/29/2004 7:35 PM
U
M80
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
10
320.92
377.69
USD
true
DL
4154
ABY
ATL
09/28/2004 4:22 PM
09/28/2004 5:22 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
1204
ATL
LGA
09/28/2004 6:30 PM
09/28/2004 8:54 PM
U
763
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
237
LGA
ATL
09/29/2004 3:00 PM
09/29/2004 5:35 PM
U
757
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
11
320.92
377.69
USD
true
DL
4389
ABY
ATL
09/28/2004 1:50 PM
09/28/2004 2:52 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
980
ATL
LGA
09/28/2004 3:30 PM
09/28/2004 5:48 PM
U
757
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
581
LGA
ATL
09/29/2004 6:00 PM
09/29/2004 8:35 PM
U
763
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
12
320.92
377.69
USD
true
DL
4154
ABY
ATL
09/28/2004 4:22 PM
09/28/2004 5:22 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
1204
ATL
LGA
09/28/2004 6:30 PM
09/28/2004 8:54 PM
U
763
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
1115
LGA
ATL
09/29/2004 4:00 PM
09/29/2004 6:35 PM
U
738
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
13
320.92
377.69
USD
true
DL
4154
ABY
ATL
09/28/2004 4:22 PM
09/28/2004 5:22 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
1204
ATL
LGA
09/28/2004 6:30 PM
09/28/2004 8:54 PM
U
763
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
1431
LGA
ATL
09/29/2004 5:00 PM
09/29/2004 7:35 PM
U
M80
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
14
320.92
377.69
USD
true
DL
4154
ABY
ATL
09/28/2004 4:22 PM
09/28/2004 5:22 PM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
1204
ATL
LGA
09/28/2004 6:30 PM
09/28/2004 8:54 PM
U
763
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
581
LGA
ATL
09/29/2004 6:00 PM
09/29/2004 8:35 PM
U
763
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
15
320.92
380.79
USD
true
DL
4377
ABY
ATL
09/28/2004 10:10 AM
09/28/2004 11:02 AM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
846
ATL
RDU
09/28/2004 12:50 PM
09/28/2004 2:09 PM
U
M80
0
Atlanta
GA
US
Durham
NC
US
DELTA AIRLINES
URA7LTN
true
DL
5507
RDU
LGA
09/28/2004 3:05 PM
09/28/2004 4:40 PM
U
CRJ
0
Durham
NC
US
New York
NY
US
DELTA AIRLINES
false
DL
1472
LGA
ATL
09/29/2004 10:00 AM
09/29/2004 12:27 PM
U
M80
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4154
ATL
ABY
09/29/2004 3:01 PM
09/29/2004 3:50 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
16
320.92
380.79
USD
true
DL
4377
ABY
ATL
09/28/2004 10:10 AM
09/28/2004 11:02 AM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
954
ATL
LGA
09/28/2004 12:30 PM
09/28/2004 2:39 PM
U
738
0
Atlanta
GA
US
New York
NY
US
DELTA AIRLINES
URA7LTN
false
DL
5408
LGA
BNA
09/29/2004 10:20 AM
09/29/2004 11:47 AM
U
CRJ
0
New York
NY
US
Nashville
TN
US
DELTA AIRLINES
false
DL
776
BNA
ATL
09/29/2004 3:40 PM
09/29/2004 5:47 PM
U
M80
0
Nashville
TN
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4353
ATL
ABY
09/29/2004 9:20 PM
09/29/2004 10:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
17
320.92
380.79
USD
true
DL
4660
ABY
ATL
09/28/2004 6:15 AM
09/28/2004 7:02 AM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
1599
ATL
CVG
09/28/2004 8:07 AM
09/28/2004 9:32 AM
U
732
0
Atlanta
GA
US
Cincinnati
OH
US
DELTA AIRLINES
URA7LTN
true
DL
1057
CVG
LGA
09/28/2004 10:50 AM
09/28/2004 12:38 PM
U
738
0
Cincinnati
OH
US
New York
NY
US
DELTA AIRLINES
false
DL
297
LGA
ATL
09/29/2004 9:00 AM
09/29/2004 11:35 AM
U
738
0
New York
NY
US
Atlanta
GA
US
DELTA AIRLINES
false
DL
4389
ATL
ABY
09/29/2004 12:23 PM
09/29/2004 1:10 PM
U
CRJ
0
Atlanta
GA
US
Albany
GA
US
DELTA AIRLINES
E
R
W
18
320.92
380.79
USD
true
DL
4660
ABY
ATL
09/28/2004 6:15 AM
09/28/2004 7:02 AM
U
CRJ
0
Albany
GA
US
Atlanta
GA
US
DELTA AIRLINES
URA7LTN
true
DL
4708
ATL
GSP
09/28/2004 10:30 AM
09/28/2004 11:29 AM
U
CR7
0
Atlanta
GA
US
Greer
SC
US
DELTA AIRLINES
URA7LTN
true
DL
