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?

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...