Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Generating fixtures

Highlighted
6 - Meteoroid

I've the following players and I'd like to create ordered matches between them. Right now I'm testing with four players but eventually I'd like to add more (pairs of players) and the process to generate fixtures without conflict in rounds. 

 

Input: 

 

Player
Rich
Erick
Peter
Alex

 

Output:

 

Round #Player 1Player 2
1RichPeter
1ErickAlex
2RichErick
2PeterAlex
3RichAlex
3ErickPeter

 

Highlighted
Alteryx Community Team
Alteryx Community Team

@ricardocg,

 

Can you explain what the logic is to create the fixtures? More than likely you can use a batch macro to create these rounds with your logic within the batch macro. You can then combine the fields into one field using a Formula tool and then use a Unique tool to remove any duplicates.

 

What have you tried so far?

 

DanM

Highlighted
6 - Meteoroid

Hello Dan, thanks for your reply.

I manage to create the matches (using Cross Tab and Join) and filter out the duplicates (using a formula to identify them and filter out), but I haven't found a solution for the fixture number

Highlighted
6 - Meteoroid

I made it by myself! (With the help of my colleagues to materialize the problem's logic into Alteryx)

 

I used an iterative macro to pick matches and generate rounds while avoiding match collisions in the same round. If the number of players change, the N in the same will have to be adjusted as well (inside the macro)

 

Please see the attached packaged workflow if interested.

Labels