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 | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #279: How many Olympic Games per Continent?

garinmartik
5 - Atom

Solution!

doates003
5 - Atom
Spoiler
Challenge 279.PNG

Going for the gold!

Neetu
8 - Asteroid

my Solution 🙂

 

Spoiler
solution1:

solution1.png

solution 2: 

 

solutio2.png

AngelosPachis
15 - Aurora

Challenge #279 is done!

 

Spoiler
AngelosPachis_0-1629107923309.png

 

SophieJoanna
5 - Atom
Spoiler
SophieJoanna_0-1629112633365.png

 

AdhirKirtikar
7 - Meteor

Here are my solutions:

Spoiler
Solution 1: Fuzzy Match with Find Replace
Solution 2: RegEx
challenge_279_AdhirKirtikar.jpg

VizChic
10 - Fireball
Spoiler
trim:
VizChic_0-1629166016576.png

 

Spoiler
regex
VizChic_1-1629166043733.png

 

FG AA soln

Harrylosborne
8 - Asteroid

My massively long-winded but trim-less solution:

Spoiler
Harrylosborne_0-1629372238997.png

 

Spatial_Sorcerer
6 - Meteoroid

Third challenge down, hundreds to go. Admittedly, I peeked at the solution to find out what tool to use in the non-trim path, but I did come up with the expression on my own.

Kaitlin-Sheehan
Alteryx
Alteryx
Spoiler
Spoiler
Used Trim Functionality for Solution One and Text to Columns/Data Cleansing for Solution Two. 
Challenge 279.png