We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and
join in on the fun here.
Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
My answer differed slightly from the solution, but I assume that's related to parsing the text initially. Enjoyed this challenge
This could have been a gotcha if they didn't give the hint!
Spoiler
The hint obviously told us to go to the input (notice it's not a Text Input tool but an actual Input tool?) and expand the Field Length:
Once I'd fixed the input, I simply tokenised to rows on each entire word: \<\w+\> then removed the empty cells and used the Summarise tool to group and count on each word. I then summed that to give me a total word count and Appended it back. Then I simply sorted and calculated the Percentage of total.
Once I'd fixed the input, I simply tokenised to rows on each entire word: \<\w+\> then removed the empty cells and used the Summarise tool to group and count on each word. I then summed that to give me a total word count and Appended it back. Then I simply sorted and calculated the Percentage of total.
Nice.
M.
