Forum Discussion
Count Occurrence with Index
You've switched the requirements on me. What's the desired output from that last sample data?
Hello the two original tables' data lacks a useful key to join the two tables tables. By using an idex based on the order of Duty, Block and Show Time I can then join the tables with an output I have below. Now I have some useful data. But without being able to increase the count for each Show Time it will not work, there could be two to three flights between the Show Times that need to be skiped.
Thanks
John Haase
PICSICOver-20 PICFlightDaysDayFlight2Hours3PIC4SIC5Fourth Pilot
| 3000 | Duty | 15 | 1 | 2 | 0 | 1 | 1 | Show Time | 1 | 2 | ||
| 3000 | Block | 13 | 1 | 2 | 0 | 1 | 1 | Flight | 13 | 1 | 2 | 1 |
| 3000 | Duty | 18 | 1 | 2 | 0 | 2 | 2 | Show Time | 1 | 2 | ||
| 3000 | Block | 12 | 1 | 2 | 0 | 2 | 2 | K4 807 | 8 | 1 | 2 | 0 |
| 3000 | Duty | 14 | 1 | 2 | 0 | 3 | 3 | Show Time | 1 | 2 | ||
| 3000 | Block | 12 | 1 | 2 | 0 | 3 | 3 | Flight | 12 | 1 | 2 | 1 |
| 3000 | Duty | 6 | 1 | 2 | 0 | 4 | 4 | Show Time | 1 | 2 | ||
| 3000 | Block | 4 | 1 | 2 | 0 | 4 | 4 | Flight | 4 | 1 | 2 | 0 |
| 3000 | Duty | 16 | 1 | 2 | 0 | 5 | 5 | Show Time | 1 | 2 | ||
| 3000 | Block | 14 | 1 | 2 | 0 | 5 | 5 | Flight | 14 | 1 | 2 | 1 |
| 3000 | Duty | 22 | 1 | 2 | 1 | 6 | 6 | Show Time | 1 | 2 | ||
| 3000 | Block | 15 | 1 | 2 | 0 | 6 | 6 | Flight | 8 | 1 | 2 | 0 |
| 3000 | Duty | 17 | 1 | 2 | 0 | 7 | 7 | Show Time | 1 | 2 | ||
| 3000 | Block | 13 | 1 | 2 | 0 | 7 | 7 | Flight | 12 | 1 | 2 | 1 |
FlightDayFlightDaysAssignmentFlight2PICSICOver-20 PICHoursHours3
3000 1 1 Duty Show Time 1 2 0 15 3000 1 1 Block Flight 1 2 0 13 13 3000 2 2 Duty Show Time 1 2 0 18 3000 2 2 Block Flight 1 2 0 12 8 3000 3 3 Duty Show Time 1 2 0 14 3000 3 3 Block Flight 1 2 0 12 12 3000 4 4 Duty Show Time 1 2 0 6 3000 4 4 Block Flight 1 2 0 4 4 3000 5 5 Duty Show Time 1 2 0 16 3000 5 5 Block Flight 1 2 0 14 14 3000 6 6 Duty Show Time 1 2 1 22 3000 6 6 Block Flight 1 2 0 15 8 3000 7 7 Duty Show Time 1 2 0 17 3000 7 7 Block Flight 1 2 0 13 12 Hi johnlhaase,
Could you pls also provide your expected output based on your sample data?Best with your logic.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
