Assigning Hires to Open Positions
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
We hire people with similar skill sets to the same requisition and then assign them to teams on the back end.
I'm trying to create a workflow that prioritizes open positions by team and city but takes into account the new hires' team preferences -- they provide 1st and 2nd preferences. Once a team's open positions are filled, anyone left should go to their 2nd preference team, and if there's no spots open on either their 1st or 2nd preference team, they should go to a separate tab indicating further review is needed.
Attached is sample new hire data.
Below is an example of open positions by team and city that goes with the sample new hire data:
Team | City | Open Positions |
Blue Team | Dallas | 17 |
Blue Team | Houston | 8 |
Green Team | Dallas | 3 |
Green Team | Houston | 45 |
Green Team | Oklahoma City | 3 |
Green Team | San Antonio | 2 |
Green Team | Tulsa | 1 |
Orange Team | Houston | 5 |
Pink Team | Dallas | 6 |
Pink Team | San Antonio | 1 |
Purple Team | Dallas | 5 |
Red Team | Dallas | 10 |
Red Team | Houston | 1 |
Yellow Team | Dallas | 15 |
The output goal is to have:
Candidate ID | City | Team Assignment |
I've been spinning my wheels on this one for several days and would really appreciate any and all guidance!
Solved! Go to Solution.
- Labels:
- Best Practices
- Datasets
- Macros
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@TMartin007
Maybe there is more elegant way.
I use the tile tool to sequence the combination of City and Team in both inputs,
Then we can do one join for first preferrence and a second join on 2nd preference.
What is left is for review.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @TMartin007
Kindly consider the below.
I stepped through my logic (so it might be tool "heavy" 😎).
I hope you find it helpful - Cheers!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You can work through problems like this with ranking and priority matrices. I don't want to work it out for you, but point you in the direction to go.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You're most welcome @TMartin007!
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)