community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Assign Work Based on Worker Capacity

Meteoroid

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_IDValue
REQ019400
REQ018300
REQ017200
REQ002150
REQ003150
REQ001100
REQ007100
REQ008100
REQ015100
REQ016100
REQ00480
REQ00570
REQ01070
REQ01170
REQ01270
REQ01370
REQ01470
REQ00650
REQ00950
REQ02010

 

Table - 2:Capacity (changes everyday)

TechnicianCapacity
Ann4
Bob3
Con3

 

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_IDTechnician
REQ019Ann
REQ018Ann
REQ017Ann
REQ002Ann
REQ003Bob
REQ001Bob
REQ007Bob
REQ008Con
REQ015Con
REQ016Con
Highlighted
Alteryx Certified Partner

I attached a very simple solution, but hoefully it solves your problem

2019-01-15_10-58-27.jpg

Use a generate rows tool to create a slot for each worker and then you can use a join by record position to fill the slots

Meteoroid

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.

Labels