Weekly Challenge

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

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

Submit Feedback
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.

Challenge #121: World Cup 2018!

Highlighted
Alteryx Community Team
Alteryx Community Team

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!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
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.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

Highlighted
8 - Asteroid

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

 

Highlighted
14 - Magnetar
14 - Magnetar

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

Highlighted
8 - Asteroid

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

 

 

Highlighted
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
Highlighted
5 - Atom

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

Highlighted
12 - Quasar

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