First, for year 2008 the words "NEVER" and "ONE" each occur 19 times and are 10 and 11 on top 10 count. So,they both need to be included in the top 10 count. "ONE" needs to be added to 2008 top ten word list.
Second, one of the strengths of Alteryx is it's ability to clean up dirty data. Why wouldn't the solution be represented by this process?
I've got a better grasp on why I dislike Taylor Swift... Or perhaps why I stopped listening to the music that was written for her or by her...
Here's my take on parsing and counting these lyrics
Hi folks - this is my first ever Alteryx Challenge! Let me know if I don't post this correctly!
Looking through others pictures, it looks like I have some opportunities to simplify, but not too bad overall.
I also had the challenge where my numbers don't 100% align to the answer, so interested to read more on why that is. I tried with and without cleaning steps to no avail.
Thanks for the challenge,
Here is my proposed solutions, having a small discrepancies with the proposed output as well despite using the latest start file. Quite interested to see how my grouping function differs from the proposed solutions.
I'm not a much of a Taylor Swift fan, but when you work in the quick-service Restaurant industry, milkshakes are a frequent conversation topic. Getting "Shake It Off" stuck in your head is kind of an occupational hazard. 🥤
As others did, my solution has a few little differences from the provided solution. I'll be interested to see how it was solved!
Workflow (my solution is pretty similar to many others):