We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #102: Tabulating Flu Data

ShashankRaj12
8 - Asteroid

  

vbrown
8 - Asteroid

My solution.

hichen
Alteryx
Alteryx

😃

vaprevil
7 - Meteor

Solved

 

 

Laurap1228
11 - Bolide

here is my solution:

 

Spoiler
Laurap1228_0-1623361182845.png

 

kglearner
7 - Meteor
Spoiler
Weekly Challenge 102.PNG

Nvy
8 - Asteroid

Started the day with an Alteryx Challenge. Feels good.

BronzeFox
8 - Asteroid
Spoiler
Submission attached
euanwilson
8 - Asteroid
Spoiler
So the first select records tool was used to remove the first two rows and the select tool was used to remove the irrelevant columns and change field 8 entries into double format. I then used the summarise tool to sum the amount of cases for each age group per season. The crosstab tool was used to turn each age bracket from being grouped into one columns to making up each header column. 
The final 2 select record tools and the select tool were just used to tidy up the data set so that it matched that of the given output. 

Workflow.PNGResults.PNG
j_trefethen
8 - Asteroid
Spoiler
Challenge 102 - JT solution.jpg