ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #121: World Cup 2018!

jwlong91
Asteroid

This was a really fun challenge!  Great for learning more about Regex!

Falk
Atom
 
brandnewday
Meteor

My solution! So happy I could do something World Cup-related that would save me from mourning over England's loss to Croatia at semi-finals today. Football isn't coming home just yet...

 

12 tools, I'm satisfied:)

 

 

Spoiler
Challenge_121_brandnewday.PNG

 

LordNeilLord
Aurora

Solution

 

Spoiler
121.PNG
JordyMicheal
Bolide

I need to get better at regex and not text to columns haha

CHarrison
Asteroid

Bit late, but got it :) 

data_rachel
Asteroid
Spoiler
challenge121.PNG
MattKing
Asteroid

 

Here is my solution

I have a run time of 1.6 seconds VS Alteryx solution of 2.8 seconds. First time I beat the run time

PhilipMannering
16 - Nebula
16 - Nebula

I like @danrh and @estherb47 (and whoever else did it) method of concatenating first. Nice trick.

 

Spoiler
Challenge 121 - Capture.PNG

 

 

AndrewRein
Asteroid