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

SitanshuPatnaik
Météore

#8

Yongcan
Astéroïde

These space is UTF8 version non-breaking space with HEX code "C2 A0".

I notice that too and spend some times to figure it out why my output is not matching the expected result.

 

https://www.scivision.dev/hex-code-c2a0-non-breaking-space-markdown/

https://en.wikipedia.org/wiki/Non-breaking_space

 

My solution use a lot data cleansing as Trim function won't help here for ASCII space.

 

2023-11-05 23_21_23-JAB10W7451336 - JAB10W7451336 - Remote Desktop Connection.png

ricki
Astéroïde
Révélation

I thought that renaming the columns manually was too straightforward - so I got a nice reminder of Dynamic rename and the Field Info tool, which are both useful and I somehow keep forgetting about the latter.

spoiler_355.png

 

TimN
Pulsar

Hi,

Here is my solution.

pmag
Astéroïde
Révélation
Screenshot 2023-11-29 110619.png
RasmusFormo
Astéroïde
Révélation
355.png
leonardstarrk
Astéroïde

Renaming by hand is a bit of a drag, but here it goes

sakifchowdhury1
Astéroïde
Révélation
355 ss.png

Challenge 355 solution

Kushangi3012
Météoroïde

Solution Attached

Rohit_Pokhriyal
Météore

Thank you!