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 #205: Taynalysis

Highlighted
8 - Asteroid

that was fun.. took me a while to parse the text to match the output.  but got there

Highlighted
8 - Asteroid
8 - Asteroid

Keep up the momentum

Highlighted
9 - Comet

Hi,

 

Here is my answer. 

 

Best Regards,

Samuel

Highlighted
Alteryx Certified Partner

My answer did not match the Output provided either.

 

After looking into the official solution, I came up with this

 

Spoiler
So, I could see, that along the way it was pretty much the same, but the major difference in the result, is how you define the words to begin with.

If you haven't already, I would recommend that you also take a look at the official solution provided, since it actually contains some great comments on why there is the discrepancies, depending on how you try to solve this challenge.

Anyway here's my take on it.
Workflow and commentsWorkflow and comments I guess nothing is absolute

Still Climbing
/Verakso

Highlighted
7 - Meteor

This was an interesting one!

I decided to eliminate the word "should've," one the Top 10 Words in the 2006 album from the official solution, because it's a contraction of two Stopwords. In my solution, the word "beautiful" takes its place.

 

Spoiler
Challenge_205_Solution.JPG

 

 

Highlighted
8 - Asteroid

I don't match the solution results exactly because I used the cleaning tool instead of regex, but close enough for me...

Highlighted
12 - Quasar
Spoiler
Challenge #205.PNG

Highlighted
8 - Asteroid

Took me quite a long time to realise I was using Replace instead of Replacechar. Need new glasses!

Highlighted
7 - Meteor
Spoiler
TC_bot_2-1595292150258.png

 

TC_bot_1-1595292117789.png

 


The trick is to count the unique lines prior to removing the 'stop words'.

Be sure to check the solution file's output results  before starting. The output results listed in the start file are incorrect

Highlighted
8 - Asteroid

Heres Mine

 

Spoiler
Carlithian_0-1595938889907.png