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 #112: Organizing Survey Data

NicolaMahood
8 - Asteroid
Spoiler
NicolaMahood_0-1671699670096.png

 

elaineyuan
8 - Asteroid

I do everything I can to avoid using RegEx, even if it means I use five Parse tools.

 

Spoiler
challenge_112_elaine_yuan.png
kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_112_KU.png
myastarling
10 - Fireball

Here's my solution.

leonhekkert
8 - Asteroid

My solution:

 

Spoiler
Unfortunately its not dynamic at all. But I figured making it dynamic would cost me a lot more time than just renaming through the select tool.

challenge_112.png
CaraI
Alteryx
Alteryx
Spoiler
Spoiler
 

I went with a multi-field formula to eliminate a lot of parsing.

CaraI_0-1678916483569.png

 

phottovy
13 - Pulsar
13 - Pulsar

Not as dynamic as I would like but gets the job done.

 

Spoiler
112.png
CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1679809619236.png
alacoume
8 - Asteroid

My solution:

alexnajm
16 - Nebula
16 - Nebula

Done!

Spoiler
Challenge 112.PNG