The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

jamaldub1
Asteroid

Sick Challenge!

Endeavour
Comet

Hi all,

 

Here is my solution.

Spoiler
Challenge_108.png

Thank you

Hi! Here's my solution.

 

Spoiler
Spoiler102_FlowScreenshot.jpg

Hi! Here's my solution.

 

Spoiler
Spoiler102_FlowScreenshot.jpg

vinspad
Asteroid

I couldn't get this to go through without warnings due to nulls which was annoying, but it works!

erica_sch
Asteroid
Spoiler
erica_sch_0-1758040749262.png

 

Micah_E
Meteoroid
Spoiler
Micah_E_1-1759413981551.png

 

mattnason1
Comet

I cheated on the headers since I like the sample/union trick that a former coworker current ACE showed me.

SamHD
Asteroid

I used to not understand the Cross Tab tool at all... but I did this one fairly fast with no looking anything up. Progress!

Spoiler
SamHD_0-1761145731793.png