Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #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
16 - Nebula

Challenge #279 is done!

 

Spoiler
AngelosPachis_0-1629107923309.png

 

SophieJoanna
7 - Meteor
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
11 - Bolide
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