community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #102: Tabulating Flu Data

Asteroid

My solution below

 
Asteroid

This was a good one. 

 

To get around the cross tab tool changing field names, I leveraged @Nicholas_Brill 's technique found here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Cross-Tab-Column-Header-Issue/td-p/121...

 

Asteroid

Learned how to use the custom filter tool!

Alteryx Alumni (Retired)

Fun with dynamic renames. Kept it short and sweet.

Alteryx Certified Partner

Done! But I may have used a lot of tools to do so.

Spoiler
102.png
Asteroid

Here's my solution!

Spoiler
Capture.JPG
Alteryx
Alteryx
Spoiler
Previous challenge showed me how to use dynamic rename to quickly name columns.  Very handy tool!
Asteroid
Spoiler
2019-07-21 14_42_29-Greenshot.pngGetting better with the Cross Tab tool
Asteroid
Spoiler
Challenge #102.png