Hi guys
I have got a duplicated events issue as below. each event id, there are two duplicated records , but the time is little bit different. MaY I know how to only replace the status value to Open for the earlier event for each event id.
Eventname Eventid Eventtime status
hello 001 1:00 closed
hello 001 1:01 closed