Assigning Hires to Open Positions

[TMartin007]

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!

[Qiu]

@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.

[RobertOdera · Accepted solution]

Hi, @TMartin007 

Kindly consider the below.

I stepped through my logic (so it might be tool "heavy" 😎).

I hope you find it helpful - Cheers!

[32bit]

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.

[RobertOdera]

You're most welcome @TMartin007!