We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #121: World Cup 2018!

Alteryx Alumni (Retired)


Last week's solution can be found HERE!


Let the games begin…the World Cup games, that is! For this Week’s Challenge, we’re going to list the scheduled matches for the 2018 World Cup.  Create a workflow to parse the input data to create a sorted list (by date) of the scheduled matches and their locations, as well as the host stadium’s capacity of cheering fans.  There’s plenty of room for creativity with this one, from reporting to app building, so feel free to make it your own!

17 - Castor
17 - Castor

I'm looking forward to some RegEx solutions that don't use so many Text-to-Columns tools. 

6 - Meteoroid

I had to time box this one, practicing for the certification exams, for some crazy reason, my RegEx ^\d* worked on all but the parse choice so, I took the lengthy text to columns path.  My not elegant but correct solution.

14 - Magnetar
14 - Magnetar

My version, same problem, some regex would have made it a lot cleaner but quite challenging, nice one !

8 - Asteroid

Here's what I've got. Lots of fun Regex opportunities! I'm interested in seeing who can make theirs the shortest.



ACE Emeritus
ACE Emeritus

My solution! With a special shoutout to @MarqueeCrew. I have learned the error of my non-Expect-Equal-Tool-using ways. :)


Combo of my secret-weapon Make Columns tool + Text to Columns + a little RegEx... overall, fairly pleased with a reasonably small number of tools!




8 - Asteroid

My first entry. A little long, but I will get there.



7 - Meteor
Next step would have been to make an analytical app that allows the user to select the date and have the report populate automatically! There is easier ways to do this though.
Challenge 121.PNG
5 - Atom

My first weekly challenge! Long, and no regex. Hopefully can only do better in the coming challenges.

12 - Quasar

A bit brute force at times and not as elegant but definitely gets there!