Hi all
I run a weekly workflow based on people leaving our Firm, and sending them email reminders to return their IT equipment.
prior to their departure.
The workflow has worked fine up to now, but I have just notice a flaw in my logic.
Occasionally we have a situation where someone 'resigns' from the firm, but then rescinds their request - my workflow only picks up the terminations that are competed successfully - it does not pick up where resignations are rescinded, leaving my team with a slight embarrassment.
In the example below John Smith has resigned and is leaving on 30th Oct, and his request was completed on 25th Oct.
On 27th Oct he rescinded his resignation, cancelling out the original request,
| Departer name | Business Process Type | Transaction status | Completed Date | Departure Date |
| John Smith | Termination | Completed successfully | 25-Oct-19 | 30-Oct-19 |
| John Smith | Termination | Rescinded | 27-Oct-19 | 30-Oct-19 |
Is it possible to set up a filter or formal that would resolve this ?
I have limited knowledge of Alteryx Workflow, and just don't have the brainpower to work this question out. 😆
