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

KKSzpakowski
8 - Asteroid

Thank you for the challenge!
I was able to complete it.

Regards
K

CammyPhillips
8 - Asteroid
Spoiler
CammyPhillips_0-1674145639520.png

 

BS_THE_ANALYST
15 - Aurora
15 - Aurora

I like the idea of converting to Titlecase and then performing the counts. The the .. should be grouped if we're counting the instances of the actual words. In English, the/The are the same 😂. I'm not entirely sure I'm going to say 'Hey, by the way, I said hey with a captial H!'

Spoiler
BS_THE_ANALYST_0-1674408392095.png

 

 

All the best,
BS

LinkedIN

Bulien
François_Rs
8 - Asteroid

Franois_Rs_0-1674491795348.png

I didn't manage to find the exact same results

 

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1675177443400.png

 

caltang
17 - Castor
17 - Castor

Can't match exactly, but I managed to do it in a way which is replicable for other Strings:

 

Spoiler
caltang_0-1675583148808.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
gaoa
11 - Bolide
Spoiler
Finally matched solution!
gaoa_0-1675872021552.png

Learned something new about RegEx tool -- splitting entire words to rows.

gaoa_1-1675872744607.png

 

Dani_Lin
8 - Asteroid

solved

longyanChen
8 - Asteroid

hi

Heinrich_Preuß
8 - Asteroid
Spoiler
Heinrich_Preu_0-1676044377114.png

 

The solution has less 'the' because it doesn't include 'The' and 'THE' which I would consider as the same word