community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #182: Word Sleuthing

Meteor

I also get different results even after following the solution.

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


Meteoroid
 
Alteryx Certified Partner

My solution

 

Spoiler
challenge_182.PNG
Asteroid

Hi! Here my solution

 

guys'n'gals enjoy Inspire Europe!

Alteryx Certified Partner
Spoiler
Capture.PNG
Atom
Spoiler
challenge_182_Orion_Huey.PNG
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.

Meteoroid

Thanks for the challenge! pretty straightforward.

 

Spoiler
clipboard_image_0.png
Asteroid