Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Assign Work Based on Worker Capacity

ayx-droid
7 - Meteor

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
4 REPLIES 4
RolandSchubert
16 - Nebula
16 - Nebula

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

jdunkerley79
ACE Emeritus
ACE Emeritus

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

ayx-droid
7 - Meteor

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.

Gina2021
8 - Asteroid

@RolandSchubert 

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!

Labels