community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #121: World Cup 2018!

Sr. Learning Strategy Manager
Sr. Learning Strategy Manager

generic.png

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!

Alteryx Certified Partner

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

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.

Comet

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

Meteor

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

Spoiler
Capture.PNG

 

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

 

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

WeeklyChallenge121.JPG

Cheers!

NJ

Asteroid

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

 

 

Alteryx Certified Partner
Spoiler
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

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

Bolide

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