Hi, I have a list of managers and analysts that need to be shuffled each quarter. there is 1 manager for each team and each quarter the analysts get shuffled around. I need some assistance on how to create this workflow. Thanks in advance
Input
Manager | Andrew |
Manager | Elijah |
Manager | Isaac |
Analyst | Brianna |
Analyst | Chris |
Analyst | Derek |
Analyst | Farah |
Analyst | Garrett |
Analyst | Harrison |
Analyst | Jarred |
Analyst | Karen |
Output
Q1 | Q2 | Q3 | |||||
Manager | Andrew | Manager | Andrew | Manager | Andrew | ||
Analyst | Brianna | Analyst | Farah | Analyst | Harrison | ||
Analyst | Chris | Analyst | Jarred | Analyst | Garrett | ||
Analyst | Derek | Analyst | Karen | ||||
Manager | Elijah | Manager | Elijah | Manager | Elijah | ||
Analyst | Farah | Analyst | Brianna | Analyst | Chris | ||
Analyst | Garrett | Analyst | Derek | Analyst | Jarred | ||
Analyst | Harrison | Analyst | Karen | ||||
Manager | Isaac | Manager | Isaac | Manager | Isaac | ||
Analyst | Jarred | Analyst | Chris | Analyst | Brianna | ||
Analyst | Karen | Analyst | Harrison | Analyst | Derek | ||
Analyst | Garrett | Analyst | Farah |
Hi @chris4987 ,
I've achieved this by using random number generation and sorting by this, then using the tile tools to assign managers and analysts to equal sum tiles. I then joined the analysts to managers using the assigned tile number. You can then copy this out for as many Quarters as you wish to assign in the future.
The number of tiles corresponds to the number of managers.
Workflow attached.
I hope this helps.
M