Round Robin Work Allocation within Capacity

[bigbang]

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.

[NeoInfiniTech]

Hello @bigbang,

Please take a look at the attached workflow.

[bigbang · Accepted solution]

Hello Neo,

There are 2 separate files 

1. File1: IDs

2. File2: Assignee, capacity

[NeoInfiniTech]

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

[NeoInfiniTech]

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]

Thank alot Neo, this worked perfectly.