I'm trying solve the problems below but not sure where to start.
from the datasets below, I need to:
1. Select Ticket_ID's based on the total capacity of each technician.
- Can sampling be done based on variable name?
2. Assign selected tickets (in previous) step to each technician (based on capacity).
Appreciate your suggestions.
Table - 1: Tickets Received (Sorted based on value)
Ticket_ID | Value |
REQ019 | 400 |
REQ018 | 300 |
REQ017 | 200 |
REQ002 | 150 |
REQ003 | 150 |
REQ001 | 100 |
REQ007 | 100 |
REQ008 | 100 |
REQ015 | 100 |
REQ016 | 100 |
REQ004 | 80 |
REQ005 | 70 |
REQ010 | 70 |
REQ011 | 70 |
REQ012 | 70 |
REQ013 | 70 |
REQ014 | 70 |
REQ006 | 50 |
REQ009 | 50 |
REQ020 | 10 |
Table - 2:Capacity (changes everyday)
Technician | Capacity |
Ann | 4 |
Bob | 3 |
Con | 3 |
Selection of requests and allocation:
Based on the capacity, which is 10 in the example, I need to select the tickets from table 1 and allocate to each technician
Table 3 - Expected Result
Ticket_ID | Technician |
REQ019 | Ann |
REQ018 | Ann |
REQ017 | Ann |
REQ002 | Ann |
REQ003 | Bob |
REQ001 | Bob |
REQ007 | Bob |
REQ008 | Con |
REQ015 | Con |
REQ016 | Con |
Solved! Go to Solution.
rschubert and jdunkerley79 Thanks to both for the solution you provided. I've tested both of these solution and works flawlessly. I've marked rschubert as solution, but jdunkerley79 solution is as good as rschubert.
Thank you sooo much!!!! I had this super long and clunky workflow going on, and your contribution just let me delete 2/3 of my tools! Thank you!