Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI love completing a challenge and then looking at how other people used different tools to get to the same solution. While I am still learning I just try to get to the right answer, but as time goes by and data sets get bigger - getting to the right answer faster will be the challenge.
Thanks for the Challenge! 2nd overall challenge attempt, and the first solution I was able to solve accurately start to finish without needing to google any alteryx "how-to" concepts and rely on the awesome community posts to get me to the end!
Took a bit different approach Using the Find and Replace tool to append the "type" to the ticket orders then used formula tool to create a flag for the higher level categories vs. the multiple Joins approach in the posted solution.
My solution