Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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 #234: Spell It Out For Me - Part 1

Qiu
21 - Polaris
21 - Polaris

It's more fun to do it in a dynamic way.

Révélation
en-234.PNG
purnimat
Météore

Quite late to the party ! Here is my solution

Révélation
purnimat_2-1600869388728.png

 

 

ggruccio
ACE Emeritus
ACE Emeritus

Fun and made me think!

 

Révélation
Key is to convert to string then pad with zeros then parse and convert back to byte.ggruccio_0-1600869938256.png

 

cpapaioannou
Météore
Révélation
cpapaioannou_1-1600878134365.png

 


 

gregurbanowicz
Météore

And now we wait for Part 2 ... 

 

 

Solution attached

mike_w
Astéroïde

this was fun. Looking forward to part II 

Révélation
mike_w_0-1600892648226.png

 

Jean-Luc
Atome
Révélation
Nice Solution! I tried to do the same dynamic append method but hard coded the Regex Token to 12 columns. I didn't think about splitting to rows and then using cross tab - good idea!
AdhirKirtikar
Météore

Easy peasy, only 3 tools required.

 

Révélation
challenge_234_AdhirKirtikar.png

Edit: Added Dynamic solution, equally easy 🙂

Révélation
challenge_234_AdhirKirtikar_Dynamic.png

 

The solution file attached.

Inactive User
Non applicable

🙂

Challenge 1.PNG