This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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!
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.
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.
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.