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?

xAJBx
7 - Meteor

Spoiler
xAJBx_0-1627926838524.png

 


 

Emil_Kos
16 - Nebula

Hi,

 

Fun and easy one!

 

Emil_Kos_0-1627938680550.png

 

TonyA
Alteryx
Alteryx

Generally not a big fan of using Trim() except for leading and trailing spaces. Works here because none of the continents end in "h"

Spoiler
TonyA_0-1627942161433.png

 

kelvinlaw
8 - Asteroid

Here are my 2 solutions:

Spoiler
Solution 1 with Trim Formula, Solution 2 with Regex Replace
kelvinlaw_0-1627974763373.png

 

aakashraj
6 - Meteoroid

Here is my approach to the challenge.

kunderwood
7 - Meteor
Spoiler
kunderwood_0-1627994065428.png

 

MatthewBr
Alteryx
Alteryx

Here is my solution to this weeks challenge.

lzhang21
Alteryx
Alteryx
Spoiler
solution_279.PNG
JasonHu
8 - Asteroid
Spoiler
workflow.png

Here is my submission. no trim function in both methods.

DanTh
Alteryx
Alteryx
Spoiler
I definitely spent way too long on this. I did technically create two different versions (neither of which used "Trim"), but probably the Append + Contains combo makes the most sense.
Dan_0-1628008426687.png

 


4/5

 Made this much harder for myself by trying to make the cleansing generic...