SOLVED
Round Robin Work Allocation within Capacity
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
bigbang
6 - Meteoroid
‎08-05-2024
03:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
Labels:
- Labels:
- Transformation
5 REPLIES 5
NeoInfiniTech
11 - Bolide
‎08-05-2024
03:51 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎08-05-2024
03:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
NeoInfiniTech
11 - Bolide
‎08-05-2024
04:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
NeoInfiniTech
11 - Bolide
‎08-05-2024
04:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
‎08-05-2024
04:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank alot Neo, this worked perfectly.
![](/skins/images/2A479D0ADEFDAA8078B5B9F489A80DDD/responsive_peak/images/icon_anonymous_message.png)