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
Asteroide
Saqueador
NicolaMahood_0-1671699670096.png

 

elaineyuan
Asteroide

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

 

Saqueador
challenge_112_elaine_yuan.png
kristiadiuisan
Asteroide
Saqueador
Alteryx_challenge_112_KU.png
myastarling
Bola de fogo

Here's my solution.

leonhekkert
Asteroide

My solution:

 

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

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.

 

Saqueador
112.png
CeliaC_Silje
Asteroide
Saqueador
CeliaC_Silje_0-1679809619236.png
alacoume
Cometa

My solution:

alexnajm
17 - Castor
17 - Castor

Done!

Saqueador
Challenge 112.PNG