Weekly Challenge

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

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

Submit Feedback
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.

Challenge #182: Word Sleuthing

Highlighted
7 - Meteor

I also get different results even after following the solution.

Highlighted
Alteryx Partner

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


Highlighted
6 - Meteoroid
 
Alteryx Certified Partner

My solution

 

Spoiler
challenge_182.PNG
Highlighted
8 - Asteroid

Hi! Here my solution

 

guys'n'gals enjoy Inspire Europe!

Highlighted
Alteryx Certified Partner
Spoiler
Capture.PNG
Highlighted
5 - Atom
Spoiler
challenge_182_Orion_Huey.PNG
Highlighted
Alteryx Certified Partner

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.

Highlighted
8 - Asteroid

Thanks for the challenge! pretty straightforward.

 

Spoiler
clipboard_image_0.png
Highlighted
8 - Asteroid