This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I've reworked the file, and hoping it makes more sense, but I'll explain it as follows (apologies for the names, i couldn't use real staff names here):
Boris Johnson, Donald Trump, Scott Morrison and Daniel Andrews are 'standard" terminations and processed by the workflow
Bruce Banner - resigned as a Contractor (End Contingent Worker Contract) on 13th April, and re-hired on 22nd April as FTE (Hire)
Tony Stark - resigned as FTE (Termination) on 11th December and re-hired as a contractor (Contract Contingent Worker) on 15th December
Hugh Jackman and Peter Quill both rescinded their terminations as they decides to resign at a later date therefore submitted their terminations for the new date/s
I need to find way to exclude the 2 re-hires, but they're showing due to the 'termination" field Regarding the 'rescinded' terminations i need to exclude the initial 'termination' plus the 'rescinded values - the last termination (successfully completed) needs to be picked up by the workflow
Termination, Contract Contingent Worker and End Contingent Worker Contract are fields within "Business Process Type"
Rescinded and "Successfully Completed are fields within "Transaction Status"
I might be still bit confused 🤔. But something I could make out is you just want to keep last occurrence for each staff code. This is just my assumption maybe I am missing the bigger picture. If you just want to keep the last occurrence for each staff code you can do something like this.