Hi All
I am struggling with a matching challenge and hope you guys can help: For this axample purpose, I have a list of requests from sports clubs that are in need for sports players at different levels. Some of the players cannot play for certain clubs (restricted) and some of the players don't possess the right skill and/or skill level.
For each request , how do I get to see only those players that are 1) not restricted, and 2) have the right sport skill, and 3) have the right skill level?
Have been thinking about this for days how to match each request with the right player(s), but I feel like I am running in circles. So I thought I'd give it a go in the community 🙂
Thank you! Sander
Solved! Go to Solution.
Hi @TheDataCleaner,
Thank you for sharing the matching challenge. Please see the following workflow:
The workflow is attached. I hope this helps. Best!
Dear Mot, thank you for your help, you're a legend!
Still have to try if this works on larger data set, but I am very happy with the logic of your proposal.
Keep in touch, @TheDataCleaner
Thanks!
Last but really last one: you converted columns-to-rows for Beginner level only. If I want to split Intermediate and Professional level to rows as well, do I have to do the same for each of those columns individually, or can that be done in a different way, without causing duplicates?