We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #182: Word Sleuthing

Nicole_L
8 - Asteroid

I also get different results even after following the solution.

SueDonim
8 - Asteroid

Cool.  This was surprisingly simple (at least once I understood ....)

 

Spoiler
... how to deal with
- RegEx (still learning that)
- how to get rid of the truncation problem
- found the [Null] that was making my solution one record too many

Process:
- Tokenise on \<\w+\> (and split to rows)
- Group by word and count all instances of that word
- Sort - descending on count
- Sum of all words (sum of count)
- Append to Count
- Calculate % of each word
- Filter out the [Null]

Elementary....

MySolution.PNG


HarshGarg6135
6 - Meteoroid
 
JoshuaGostick
11 - Bolide

My solution 🙂

 

Spoiler
challenge_182.PNG
RichoBsJ
10 - Fireball

Hi! Here my solution 🙂

 

guys'n'gals enjoy Inspire Europe!

LordNeilLord
15 - Aurora
Spoiler
Capture.PNG
hueyor2
5 - Atom
Spoiler
challenge_182_Orion_Huey.PNG
RWvanLeeuwen
10 - Fireball

Back from my holidays and another few challenges are there for the taking/tackling.

Spoiler
182.png

I found some minor differences, but I am unsure as to why.

JonMcMillin
8 - Asteroid

Thanks for the challenge! pretty straightforward.

 

Spoiler
clipboard_image_0.png
Luisa_Bez
8 - Asteroid