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 #410: Optimizing Winter Sports Inventory

MMC15
8 - Asteroid
Spoiler
410_MMC15.png
Zhengyi
8 - Asteroid

Nice practice.

Manav_Sehra
8 - Asteroid

My solution is attached. 

Spoiler
2024-02-02_14-07-40.jpg

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
image.png
Lucy_Hickman
6 - Meteoroid
Spoiler
2024-02-05_10-21-15.png

I noticed that all the data was in the correct order, but will many null values. I transposed the data into one column, removed all the null values. then used the sample tool to reorganize the data. 

emmaob98
7 - Meteor
Spoiler
Spoiler.png
james_western_HUN
7 - Meteor

First challenge I've tried.

 

Spoiler
I tried to stumble through a multirow formula before peeking solution. the Mod 5, Concat, and transpose was very elegant.
gerda
8 - Asteroid
Spoiler
Screenshot 2024-02-12 155650.png

Here's the solution.

Carolyn
12 - Quasar
12 - Quasar

A little ugly but I got there!

 

Spoiler
2024-02-12_16-00-54.png

Ray_Pospisil
8 - Asteroid

Alteryx, pandas, pyspark and SQL solutions