The 2 employment scenarios are (I have attached a couple of dummy files) :
I do have 2 more scenarios i have to omit, this time to deal with resignations (terminations) which affects both FTE and Contractor (I have attached a dummy file (rescinded.xlsx)
If anyone could help with even 1 scenario that would give me an idea how to proceed, and i'd be greatly appreciative
Solved! Go to Solution.
I don't quite understand the question, but the data doesn't help either 😞
In both FTE_Contractor and Contractor_FTE it's the same employee all the time.
Maybe you can add another attachment .... the result that you expect when these files are processed please ?
Thanks for your reply @cmcclellan
I thought about that, late last night, and am in the process of making up a better example sheet which I'll re-add a little later today
Sorry to the confusion
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):
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
URGENT !!!!! .... Did you mean to include Sheet1 in the attachment ?
That looks pretty good, and very close as it excludes the rescinded terminations. I'll run some tests on my live data tomorrow
However Tony Stark and Bruce Banner need to be excluded, as they are re-hires, regardless of the "Termination" and "End Contingent Worker Contract"
In Theory the Termination (Tony Stark) and End Contingent Worker Contract ( Bruce Banner) will always appear before the "Contract Contingent Worker" (Tony Stark) and "Hire" (Bruce Banner)
Hope this explanation makes sense ?
Do I have to create a seperate flow to exclude the 2 different types of re-hires, based on the rescinded terminations ?
Hi @StephenT
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.
Workflow:
Give it a try and let me know why it would fail.
Hope this helps : )
Thanks @atcodedog05 and @cmcclellan
Your workflows work perfectly and give the same results. I will mark them both as resolving my issues.
Thank you for your valued input and assistance - you have made a complicated process a lot more simple.
Just check that Terminations and Hires file - I don't know if you meant to include Sheet1, it has a lot of names in there!