We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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 #356: Spelling Bee

MajorData
Alteryx
Alteryx
Spoiler
MajorData_0-1675110431622.png

 

Nice one! I went through 3 different approaches to the RegEx. Did not attempt a macro, but I will check out some other answers. 

rmassambane
11 - Bolide

356

patrick_digan
17 - Castor
17 - Castor

Dynamic without any regex or macros

Spoiler
I used the Dynamic Replace and the replacechar function
patrick_digan_2-1675112998898.png

 


 


 

TonyAndriani
9 - Comet

This one was fun.

Spoiler
TonyAndriani_0-1675114873223.png

 

 

binuacs
21 - Polaris
Spoiler
binuacs_0-1675116054570.png

 


 

Georgia251
7 - Meteor

Not the most elegant of solutions but it got me the result I needed

cameronfraser
7 - Meteor

Good practice for the append tool and formulas.

 

Spoiler
cameronfraser_0-1675121009243.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1675121107646.png

 

logdog0411
9 - Comet
Spoiler
logdog0411_0-1675121178392.png

 

Great challenge! Took me a few attempts to figure out the RegEx elements. 

 

See you next week!

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1675140266177.png