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

KKSzpakowski
アステロイド

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

Regards
K

CammyPhillips
アステロイド
スポイラ
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!'

スポイラ
BS_THE_ANALYST_0-1674408392095.png

 

 

All the best,
BS

LinkedIN

Bulien
François_Rs
アステロイド

Franois_Rs_0-1674491795348.png

I didn't manage to find the exact same results

 

Ed2000
アステロイド
スポイラ
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:

 

スポイラ
caltang_0-1675583148808.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
gaoa
ボリード
スポイラ
Finally matched solution!
gaoa_0-1675872021552.png

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

gaoa_1-1675872744607.png

 

Dani_Lin
アステロイド

solved

longyanChen
アステロイド

hi

Heinrich_Preuß
アステロイド
スポイラ
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