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?

xAJBx
7 - Meteor

Spoiler
xAJBx_0-1627926838524.png

 


 

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Fun and easy one!

 

Emil_Kos_0-1627938680550.png

 

TonyA
Alteryx Alumni (Retired)

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

 

kelvin_law1
9 - Comet

Here are my 2 solutions:

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

 

aakashraj
7 - Meteor

Here is my approach to the challenge.

kunderwood
8 - Asteroid
Spoiler
kunderwood_0-1627994065428.png

 

MatthewBr
Alteryx Alumni (Retired)

Here is my solution to this weeks challenge.

lzhang21
Alteryx Alumni (Retired)
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...