Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #102: Tabulating Flu Data

edavilac
8 - Asteroid

Thanks for the challenge, sharing my solution!

 

Spoiler
Challenge_102_edavilac.PNG
izamryan
8 - Asteroid

I wasted ~15 minutes trying to set up the rows and columns manually building it like how I would in Excel ... but then with the Alteryx Tools I realised that step was wasted and I could've just done everything in Alteryx from the beginning ho ho ho.

 

Spoiler
izamryan_0-1590229252783.png

Used two Sample tools to tidy up the data and extract just the rows we want.
Dynamic Input tool to rename the headers.
A Select tool to set the data type of the weekly rate.

Combo of Summation tool and the Cross-tab tool to calculate the weekly rates by age and seasons.

Final Select tool to tidy up the data.

sumanthskumar
8 - Asteroid

Number 23

Spoiler
sumanthskumar_0-1590233739679.png

 

Bonero
6 - Meteoroid

my solution

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Sharing my solution. I really enjoyed this one. 

 

Spoiler
Challenge_102_Emil_Kos.PNG
mhou
8 - Asteroid

🙂

vinodkumar_mandora
7 - Meteor

.

Vikash_kumar
8 - Asteroid

Solution attached

jacob_kahn
12 - Quasar

So it seems that the biggest challenge was dynamically renaming the fields after the workflow.

 

Please see in the pictures below how I lined up the three dynamic rename tools in my workflow to re-name the fields as simply as possible for myself.

 

Spoiler
WORKFLOW
the_jake_tool_0-1591317432076.png

 

Spoiler
DYNAMIC RENAMES

the_jake_tool_1-1591317456360.png



the_jake_tool_2-1591317460466.png



the_jake_tool_3-1591317465379.png

 

Ladarthure
14 - Magnetar
14 - Magnetar

my solution