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
8 - Asteroid
Spoiler
Hjardine_0-1577669736280.png


text to rows on a space delimiter, filter out for empties, group by word, summarize for count, sort descending, append total word count to calculate % of total words. 

Highlighted
11 - Bolide
11 - Bolide

Almost precise !

Highlighted
8 - Asteroid

Hi! Here is my solution!

 

challenge_182_apabonok_spoiler.png

Highlighted
Alteryx Partner

My solution:

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

1) If yours doesn't match the provided solution, it could be:

a) case - even the top ten order is different since the solution did not group by the same case,

b) solution still has underscores,

c) more?

2) There's also the tricky questions of:

a) apostrophes - should those that represent contractions be unpacked to the constituent words?

b) hyphenated words. 

Highlighted
Alteryx Partner

 

Nice one to practice.

 

Spoiler
Input Field Length needs to be large!

bstroh_0-1578962644568.png
Highlighted
8 - Asteroid
Spoiler
solution182.png
Highlighted
Alteryx Certified Partner
Spoiler
Screen Shot 2020-01-19 at 10.27.25 pm.png
Highlighted
13 - Pulsar

Here is my solution 

 

Spoiler
Capture.PNG