In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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 #358: Goodbye, Michael! (Part 1)

ZachBowders
7 - Meteor

This was a fun one, I noticed a lot of folks aren't catching the misspellings

CMeyers
5 - Atom

I also got different results .I'm glad it wasn't just me.

CMeyers
5 - Atom

CMeyers_0-1676663132281.png

 

mwinterhack
6 - Meteoroid

Solution (Almost)

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Nice Challenge. Added an optional RegEx Tokenize method to count the number of words.

Spoiler
BS_THE_ANALYST_0-1676673482214.png

 

All the best,
BS

LinkedIN

Bulien
sylviayang
7 - Meteor

Spoiler
An interesting one! and we all love Michael. Just noticed my answer is slightly different from the output. 
sylviayang_0-1676673858592.png

 

JereJussila
8 - Asteroid
Spoiler
JereJussila_0-1676887599627.png

 

Here is my solution!

becky-pattinson
7 - Meteor

Interesting challenge, definitely difficult to not "meta-game" this one and manually search for all the possible typos.

I went for a generic regular expression to find all instances where all the characters in "michael" appeared in a the [Character] string and each only appeared once in that string.

 

 

Spoiler
beckypattinson_0-1676893798907.png

Regular Expression:

REGEX_Match([character], "^(?=(?:[^m]*m){0,2}[^m]*$)(?=(?:[^i]*i){0,2}[^i]*$)(?=[^c]*c?[^c]*$)(?=[^h]*h?[^h]*$)(?=[^a]*a?[^a]*$)(?=[^e]*e?[^e]*$)(?=[^l]*l?[^l]*$)[michael]+$")

 

 

leozhang2work
10 - Fireball
Spoiler
358.png
Laurap1228
11 - Bolide

Here is my solution - didn't use a join.

Spoiler
Laurap1228_0-1676901911081.png