Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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...