How to delete duplicated employee records due to movement
I have a scenario where we have created gap process to hire new resources, essentially adding new lines in our employee list.
However one problem coming up is sometimes we created a gap and then an existing/internal team member applied and got the job. Not sure if there is a way we can somehow delete the original record based on the employee ID (that's the code for our employee list)? Since the newly created gap has some hiring data attached to it, we will like to keep the new line.
In below example, essentially we need to delete line 1 first and then update line 2 current code with employee ID.
Appreciate the help!