Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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