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 #182: Word Sleuthing

mwong
8 - Asteroid

Uploading old solutions I have lying around

mertshepard
8 - Asteroid

Also didn't get the same count of values, even after updating the truncating issues. Solution attached.

MDestra
8 - Asteroid

Challenge #182.

Desmond
8 - Asteroid

This is one that I have picked up and put down several times.  Finally figured out how they got to the answer.  I am not sure if I agree with these counts but they match the solution so I am moving on...

Sebastian_Chaieb2
11 - Bolide
11 - Bolide

Do you like Metallica? 

Below my solution with "Enter Sandman" lyrics 🤘

Spoiler
182.PNG

BenoitC
Alteryx
Alteryx

Done!

 

Spoiler
 
 

 

 

Benoit Conley

Sales Engineer
Alteryx, Inc.

tsand22
8 - Asteroid

OPENLANE's Solution

dwstada
11 - Bolide

my solution :)

 

it differs from the challenge output because I removed several rows of strings that contain numbers, which I don't consider to be words. I also treated words like "the", "The", "THE" as the same word, and think this is a more correct solution

 

 

Spoiler
c182.PNG
ricki
8 - Asteroid
Spoiler
Great challenge, but like some other comments I read, I started getting different numbers. Eventually got it down to converting all mine to lowercase - removing this made things match. Another nice reminder to get myself more familiar with RegEx.

spoiler_182.png

RasmusFormo
8 - Asteroid
Spoiler
182.png