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 #355: Analyze the Olympic Games

Timi8
Asteroid

That "space" after the countries is not really a space. So confusing. But still a fun challenge though.  

 

Spoiler
Timi8_0-1674834548686.png

 

TonyK
Asteroid

my solution

joe_siegele
Meteor
Spoiler
joe_siegele_0-1674851334722.png

 

I tried it two ways:  using  1) Text-to-Column tools, and 2) Regex tools.

 

Spoiler
tammybrown_tds_0-1674882315451.png

 

FrederikE
Pulsar
Spoiler
FrederikE_0-1674894238547.png

 

KerenGB
Meteoroid

Solution

martinding
Pulsar
Spoiler
355.PNG

psk009
Asteroid

#355 Solution: Tools used - Text to Coulmn, Formula, Data Cleansing, Select 

 

Spoiler
psk009_0-1674977651922.png

 

RobertOdera
Pulsar

Here is my solution.

Cheers!

 

Spoiler
Challenge_355.PNG
Spoiler
SubhaSureshKumar_0-1675026696262.png