Alteryx Designer Desktop Discussions

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

Round Robin Work Allocation within Capacity

bigbang
6 - Meteoroid

Hi All,

I have two input files:

1. File1: IDs

2. File2: Assignee, capacity

 

I want to assign all the IDs among the assignees but within their capacity. The allocation of Ids should also be one by one. 

Ex if we have 3 assignees (A, 5 capacity, B, 5 capacity, C capacity 1):

Output:

ID | assignee

1 | A

2 | B

3 | C

4 | A

5 | B

6 | A  (as C has only 1 capacity.

and so on.. until their capacity is reached or IDs are no more pending. 

 

I am very new to Alteryx so any help will be appreciated.

5 REPLIES 5
NeoInfiniTech
11 - Bolide

Hello @bigbang,

 

Please take a look at the attached workflow.

bigbang
6 - Meteoroid

Hello Neo,

There are 2 separate files 

1. File1: IDs

2. File2: Assignee, capacity

NeoInfiniTech
11 - Bolide

I modified the workflow to change the ID assignment structure, please see attached workflow.

NeoInfiniTech
11 - Bolide

Please note that for the "Over Capacity" assignments in the new workflow the "Capacity" field is not used, the work is assigned in a loop regardless of capacity.

bigbang
6 - Meteoroid

Thank alot Neo, this worked perfectly. 

Labels
Top Solution Authors