Skip to Content

Group by an internal table with contition?

Jan 10, 2017 at 04:14 PM


avatar image
Former Member

Hello guys, I have an internal table with data sorted:

sort it_datos by aerolinea fecha1 hora .

I need group by matric becase I need the follow order: A - S A-S No: A-A S-S

this becase this is a table of Flights, when A: Arrivals When S: Departures. Ans I need my report wihr arrivals and departures.

here I have an error on my report:

As you can see I have not the order I want, because in XA-ACO the next row is not XA-ACO (I have market the rows like I want in pair)

The question is, how can I group this table by matric for follow the order A/S ??

salidas.png (38.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Raghu Govindarajan Jan 10, 2017 at 07:11 PM

Looks like you need to hire a programmer, or at least someone who can manage to sort an excel spreadsheet. Maybe you should put your data in to Excel and try different sorts to see what works.

In this particular case, sort by all the fields that you need an order of importance aerolina, matrlo, numero, a/s, fecha and hora.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Before down voting, why don't you try it? Your "matrlo" field groups your flights together within an airline, if you start your sort with that, they will all stay together. So Airline, Matrlo... then whatever else.

Horst Keller
Jan 10, 2017 at 05:33 PM


With additions ASCENDING|DESCENDING you can define the sort order.

10 |10000 characters needed characters left characters exceeded