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!
