Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAJust decided that I would give these challenges a go, and this one had me using a tool I never have used before. The tile tool works wonders.
So how do you get credit for completing a challenge?
Hey all,
Super late to this but just getting started working with Alteryx and figured that these challenges would serve as an excellent way to become more comfortable with the tool. That being said, here is my solution. I've yet to look at anyone else's but I am sure mine is far more complicated than need be. Would love any critiques of my workflow!
Essentially, my solution involved breaking the "Range" column into two separate columns by a "-" delimiter. Then I cleaned up those rows, renaming and reclassifying them. I counted the rows so that I could join that new column called 'Rowcount" to the original import of all the raw data.
Using the select tool, I got rid of all the unnecessary rows. Using the summarize tool, I reorganized the columns and grouped them up, using the "groupby" menu option. Finally, using the same summarize tool I added a count row, which was based on "Responder."
Let me know how I did!
Hey all,
Super late to this but just getting started working with Alteryx and figured that these challenges would serve as an excellent way to become more comfortable with the tool. That being said, here is my solution. I've yet to look at anyone else's but I am sure mine is far more complicated than need be. Would love any critiques of my workflow!
Essentially, my solution involved breaking the "Range" column into two separate columns by a "-" delimiter. Then I cleaned up those rows, renaming and reclassifying them. I counted the rows so that I could join that new column called 'Rowcount" to the original import of all the raw data.
Using the select tool, I got rid of all the unnecessary rows. Using the summarize tool, I reorganized the columns and grouped them up, using the "groupby" menu option. Finally, using the same summarize tool I added a count row, which was based on "Responder."
Let me know how I did!