Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hi,
So here is a sample. Employee X was terminated, but then rehired.
I want it as follow
Before, I used to do this manually on excel. I used to do a pivot table and put "count" to reflect how many lines they have. and then do a VLOOKUP from the pivot table to get the count and if it was more that 1, I would check it manually.
Hi @AHM
Is this workflow work well for you?
Input :
Output :
If you have any questions, please don't hesitate to contact me.
I think you can do it with a pretty simple flow. I added an extra employee in there ("ZZ") to test for scenario where someone is hired and terminated twice.
