2 data sets: trying to pair up unique pairings without reusing any value once

[JackF97]

I have 2 source data sets. lets say one has 1000 records which is a list of people with an email address and a capability they are interested in shadowing.

The other has 500 records with those people email addresses and the capability they work in and are offering to be shadowed on.

I need them to be paired if the wanted capability matches the "seniors" capability on a 1 to 1 pairing. no duplicated seniors on output and no duplicated juniors on output. So far I am having an issue getting all of them paired up without duplicates. attached is dummy data screenshots for an idea of what id like, aswell as a screenshot of how I was currently doing it which works for very small data sets but not for larger ones.

Dummy data: 

 

Current set up:

 

[jdminton]

I believe, based on what you're describing, you'll need to use an iterative macro. This is because I don't think you want individuals assigned more than once. Please let me know if that is not correct. The iterative macro will assign the seniors one at a time so that no one is assigned twice.

[JackF97]

Hi @jdminton this is right yes. I haven't worked with iterative macros before but you've described it well. The capability should match but if the junior has already been assigned to a senior, the next row with the same capability on the output should not reuse either the senior or junior

[jdminton]

Can you drop the sample data file in here?

[JackF97]

Hi @jdminton thats it attached below

[jdminton · Accepted solution]

Hey @JackF97 , I got busy on Friday. I've attached the workflow to do your request. Please take a look and let me know how it goes. Please mark as solved. Thanks!