Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
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.
