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.
