Forum Discussion

ItSupportElm's avatar
ItSupportElm
Icon for Helper III rankHelper III
5 years ago

Delete duplicate rows based on time (minute or hour)

Hello,

 

I have an issue and i cant resolv it after many research.

Here my situation : 

I want to delete duplicate data base on time , in the same hour for example for the ID "5267" i want to remove the row 03/02/2021 08:22:00 and keep the row two other row that on different date and time ( 5267 - 29/01/2021 07:50:28 and 5267 - 03/02/2021 08:21:57).

 

I dont know if my exemple is clear , if you question ask me.

Thank you for helping me.

Great Day

 

5 Replies