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 #235: Spell It Out For Me - Part 2

T_Willins
14 - Magnetar
14 - Magnetar

Used a Cross Tab tool and a Summarize tool instead of another formula to concatenate and could have collapsed the formulas into one giant formula, but that was too difficult to debug.  

 

Révélation
Workflow 235.png

 

jasperlch
Quasar
Révélation
Capture.PNG
Sashikumar
Astéroïde

Good One.

 

Révélation
ch235.PNGch235_1.PNG
Sashikumar
Astéroïde

Very Easy with formula tool . 

mbogusz
Comète

Impressive @LHolmes 

mbogusz
Comète

I took the waterfall approach instead of writing nested IF formulas to visually see it working, and that is the beauty of Alteryx- every step of the way you can visually see what's happening and see how the sausage is made.

 

Révélation
2020-09-29 06_41_38-Greenshot.png
patrick_digan
17 - Castor
17 - Castor
Révélation
patrick_digan_0-1601382507440.png

 

gregurbanowicz
Météore

I can only hope one day my checks look like phone numbers.. rather than zip codes 🙂 

 

Fun wrap up of the 2-part challenge

JethroChen
Boule de feu
Révélation
challenge_235_jc.PNG
JITHINPR
Astéroïde

My solution