Hi, I am pretty new to Alteryx so I am quite lost on how to get started here. I've been told I probably need to use a batch macro, but I am wondering if it should actually be an iterative macro?
I have two inputs. The first is a list of employee's 'bids' for the work schedule they want to get (represented by line numbers). This is pulled from an ODBC database and has a workflow already to get it into this a format like this:
| Order of Preference | ID Number | Name | Schedule Line | AM or PM | Seniority Number |
| 1 | 5555 | John Doe | 3 | AM | 1 |
| 2 | 5555 | John Doe | 3 | PM | 1 |
| 3 | 5555 | John Doe | 6 | AM | 1 |
| 1 | 9999 | Jane Smith | 2 | PM | 15 |
| 2 | 9999 | Jane Smith | 2 | AM | 15 |
| 3 | 9999 | Jane Smith | 5 | PM | 15 |
| 4 | 9999 | Jane Smith | 6 | PM | 15 |
The second input shows the work schedules available and how many slots are available in each work schedule. This is just a manual text input.
| Schedule Line | AM or PM | Slots Available |
| 1 | AM | 4 |
| 1 | PM | 6 |
| 2 | AM | 4 |
| 2 | PM | 6 |
I need to assign a work schedule by seniority and preference. So John being seniority #1 would get his first choice, but Jane being seniority #15 might not get her first choice if all of line 2's PM slots have been filled. I have thousands of 'bids' to assign.
Thank you!
