community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
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!

Alteryx Certified Partner

My solution - just a little bit RegEx and a lot of formulas (I think, things would be easier using RegEx) 

Here is my entry. Might be more complicated then it needed to be. I need to look at some others to see what they did.

 

Thanks,

Seth

Never even knew the Make Columns tool existed. I am going to try to incorporate into my workflow. Thank you @NicoleJohnson! :)

Asteroid

my solution

Asteroid

My solution :)

Spoiler
challenge_121.PNG
Alteryx Certified Partner

My attempt...

Asteroid

Quite a few text-to-columns in my solution...

I've attached my solution!

Asteroid
 
Asteroid

This is not a grand solution.  Maybe it took too long because I didn't watch enough matches.