Need to keep the first record and filter out other duplicate row

[capronton]

How can I keep the First Row in the data set and filter out the other rows with duplicate "schTime"?
I would prefer to filter the rows from the dataset, but if suppressing the rows is the best option that would be okay too.

Thanks for any help with this!

tDate incTime schTime startTrip endTrip bus
4/5/16 5:00:17 4:58 4:58 AM 6:22 AM 5013
4/5/16 5:14:18 5:13 5:13 AM 6:37 AM 5015
4/5/16 5:29:18 5:28 5:28 AM 6:52 AM 5020
4/5/16 5:44:18 5:43 5:43 AM 7:07 AM 5009
4/5/16 6:01:18 5:58 5:58 AM 7:22 AM 5017
4/5/16 6:14:18 6:13 6:13 AM 7:37 AM 5011
4/5/16 6:22:19 6:21 6:21 AM 7:59 AM 5022
4/5/16 6:15:18 6:36 6:36 AM 8:14 AM 5001
4/5/16 6:16:18 6:36 6:36 AM 8:14 AM 5001
4/5/16 6:34:19 6:36 6:36 AM 8:14 AM 5001
4/5/16 6:52:19 6:51 6:51 AM 8:29 AM 5003
4/5/16 7:04:19 7:03 7:03 AM 8:41 AM 5019
4/5/16 7:06:19 7:03 7:03 AM 8:41 AM 5019
4/5/16 7:10:19 7:03 7:03 AM 8:41 AM 5019
4/5/16 7:12:19 7:03 7:03 AM 8:41 AM 5019
4/5/16 7:17:19 7:15 7:15 AM 8:53 AM 5014
4/5/16 7:18:19 7:15 7:15 AM 8:53 AM 5014
4/5/16 7:19:19 7:15 7:15 AM 8:53 AM 5014
4/5/16 7:28:19 7:27 7:27 AM 9:05 AM 5002
4/5/16 7:33:19 7:27 7:27 AM 9:05 AM 5002
4/5/16 7:42:20 7:27 7:27 AM 9:05 AM 5002
4/5/16 7:43:20 7:27 7:27 AM 9:05 AM 5002
4/5/16 7:40:20 7:39 7:39 AM 9:17 AM 5005
4/5/16 7:53:20 7:51 7:51 AM 9:29 AM 5021
4/5/16 8:04:20 8:03 8:03 AM 9:41 AM 5018
4/5/16 8:16:20 8:15 8:15 AM 9:53 AM 5010
4/5/16 8:35:20 8:32 8:32 AM 10:02 AM 5013
4/5/16 8:49:20 8:45 8:45 AM 10:15 AM 5015
4/5/16 8:50:20 8:45 8:45 AM 10:15 AM 5015
4/5/16 8:59:21 8:58 8:58 AM 10:30 AM 5020
4/5/16 9:01:21 8:58 8:58 AM 10:30 AM 5020
4/5/16 8:47:20 9:11 9:11 AM 10:43 AM 5009
4/5/16 8:48:20 9:11 9:11 AM 10:43 AM 5009
4/5/16 8:49:20 9:11 9:11 AM 10:43 AM 5009
4/5/16 8:50:20 9:11 9:11 AM 10:43 AM 5009
4/5/16 9:15:21 9:11 9:11 AM 10:43 AM 5009

 

[Charliy]

you can use a suppression formula like:
not(onfirstrecord) and {schtime} = previous({schtime})

 

[capronton]

Thanks Charliy!
Great Forum!