ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
2 Day Countdown - The Alteryx Community will be temporarily unavailable for a few hours due to scheduled maintenance starting on Thursday, April 22nd at 5pm MDT. Please plan accordingly.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Matching challenge

TheDataCleaner
7 - Meteor

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

 

 

TheDataCleaner_0-1614032439065.png

 

mot
10 - Fireball

Hi @TheDataCleaner,

 

Thank you for sharing the matching challenge. Please see the following workflow:

 

Screen Shot 2021-02-22 at 6.47.10 PM.png

 

The workflow is attached. I hope this helps. Best!

TheDataCleaner
7 - Meteor

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

 

mot
10 - Fireball

Here is a workflow where you have a player per row. Best.

TheDataCleaner
7 - Meteor

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?

mot
10 - Fireball

You can do it the same way as well. See the updated workflow. Best.

Labels