Hi there - I have list of orders to be analyzed by reps and need to randomly assign reps. The number of orders and the available reps are not the same everyday. Based on the total orders and number of reps, need to spit equally. Same order number will get repeated in the list as well, it should have single reviewer for the day.
Table1:
Order.Nos | Rep |
1 | |
2 | |
3 | |
4 | |
5 | |
6 | |
7 | |
1 | |
3 |
Table2:
Rep |
AB |
BC |
Expected Result:
Order.Nos | Rep |
1 | AB |
2 | AB |
3 | AB |
4 | AB |
5 | BC |
6 | BC |
7 | BC |
1 | AB |
3 | AB |
Any suggestions?
The below should work as a quick solution. The one thing that would have to be updated would be the number reps in the tile tool if that changes.
@ANARK
Since you mentioned the Random, the flow get a bit larger.
Thanks MelGibson, Could you share the workflow ?