Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAFailure to Import C:\Users\etc\challenge_11_start_file.yxzp.
There was an error opening "C:\Users\etc\challenge_11_start_file\challenge_11_start_file.yxmd":
This workflow was created by a more recent version of Alteryx, and may contain tools or functionality not present in this version.
I'm on Alteryx 2018, soon to install v2019 so I'm a bit confused that a file from 2016 doesn't work. Could you update the files used here?
Now this was a head scratcher, but a real world text problem for any form of Customer Service team. Liked the challenge, and doubt this looks anything like the solution. but I got there.
Not completely correct but a solution...
formula tool to assign buckets, tranpose to get into one column, summarize tool to concatenate values, another summarize tool to count each bucket, filter for non-blanks
could have been harder without taking a little time to think first.