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?

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
I did one solution using Trim and one using RegEx. I also didn't bother breaking them out into three separate outputs, but that would be easy enough to do if needed. 
Maskell_Rascal_0-1627914440107.png

Cheers!

Phil

DaisukeTsuchiya
13 - Pulsar
Spoiler
キャプチャ.JPG

dYoast
11 - Bolide

My solutions.  I chose not to CAPITALIZE everthing.

Spoiler
dYoast_0-1627916451671.png

 

AkimasaKajitani
17 - Castor
17 - Castor

I made two solutions not used trim.

 

Spoiler
AkimasaKajitani_0-1627916471415.png

 

 

balajilolla
8 - Asteroid
Spoiler

Solution Attached

balajilolla_0-1627917751210.png

 

ggruccio
ACE Emeritus
ACE Emeritus

Europe is the clear winner!

 

Spoiler
My two ways were, one - using the trimleft and trimright to remove the unwanted characters and two - using the Text to Columns tool to parse out the '[' and data after as a separate column for the Europe[h] issue then remove all punctuation using the Data Cleanse tool.

ggruccio_0-1627917802622.png

 

ryan-bush
Alteryx
Alteryx

Solution attached

patrick_digan
17 - Castor
17 - Castor
Spoiler
I used regex and replace functions for a dynamic/non-dynamic solution.
patrick_digan_0-1627924794372.png

 

 

mike_w
8 - Asteroid

I almost missed the "provide 2 solutions" part bc I was so eager to start 😋 

Spoiler
one solution is mainly based on the Summary Tool , the 2nd one mainly on the Multi Row Formula Tool! No Trimming Tool was used.
mike_w_0-1627924868868.png

 

phottovy
13 - Pulsar
13 - Pulsar

Two solutions (which you can try using the underutilized detour tools), no trim functions: 

 

Spoiler
Unless regex counts as a trim function...
279.png