ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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