I receive a daily report detailing speed infractions for drivers. There are duplicate lines of data where the only difference is one line will be 13% over posted threshold but the next line will be 20% over posted threshold (all other info is exactly the same).
What I'm trying to do is identify duplicate line entries based on the date/time in the Alert Created column and use the Message Received information as the filtering parameters so that I can delete rows that show the 13% information while keeping the 20% information.
<tbody>
</tbody>
What I'm trying to do is identify duplicate line entries based on the date/time in the Alert Created column and use the Message Received information as the filtering parameters so that I can delete rows that show the 13% information while keeping the 20% information.
Alert Created | Message Received |
11/22/2016 10:00:00 AM | Asset exceeded the posted speed limit by 13% or more. Asset speed was 125 km/hr |
11/22/2016 10:00:00 AM | Asset exceeded the posted speed limit by 20% or more. Asset speed was 125km/hr |
<tbody>
</tbody>