Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account 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 #410: Optimizing Winter Sports Inventory

MMC15
7 - Meteor
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
9 - Comet

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