How to connect students with other students based on country?

[mrichman]

Hi Community, 

Do you probably have an idea on how to best approach to this case. I have a group of students who want to be connected with a students abroad. Currently it is based on country but would like to expand it on subjects, age etc...

With the example below we have 5 students, student 1 and 3 can be connected. As these already have been connected student 4 has no connection anymore, this is also applicable for student 5. As student 2 has and student 4 do not have the same requests, they cannot be connected. 

Thanks in advance community!

[atcodedog05]

@mrichman 

oh ok it was 5 & 6 not 4 & 5. Guess was a typo.

Hi @mrichman my previous workflow could handle that scenario do give it a look.

Output:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[mrichman]

Sorry I meant 5 and 7. 

[atcodedog05]

Hi @mrichman 

for 5 and 7 from and connect are same. How will these both connect.

[mrichman]

Thanks! I have accepted both solutions! Different roads to Rome but looks amazing to start! Will try to extent the functionalities!

[atcodedog05]

@mrichman 

Feel free to reach out if you face any roadblocks 🙂

Happy to help 🙂

Cheers and Happy Analyzing 😀

[mrichman]

Will do!  😁

[mrichman]

@atcodedog05  or @PhilipMannering 

I got two follow-up questions. Do you think this is also possible? thanks in advance!

1. What if student has "choice 1 Country" and "choice 2 Country"?

2. What if a student wants to be partnered with two more students (column partner up with more than 1 yes/no)

[PhilipMannering]

I'm sure it's possible. But how easy it is I cannot say. Looks like if you want to include a preference then an iterative macro solution might be necessary to find an optimum "StudentConnect".

Not sure I fully understand Part 2 of your question. If you were to mock up some data (with desired outcome), I'm sure @atcodedog05 or myself could see if it's possible.

[atcodedog05]

Hi @mrichman 

Here is a workflow for the task. Repeating the same process for second connect.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

@mrichman 

For the second scenario need a sample input and expected output to understand and workon😅