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
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

lukas_olsovsky
8 - Asteroid
‎03-13-2024 07:33 AM

It took me a while to get the data cleaned and sorted, thanks for the challenge!!

Running time: 0,3sec

 

Spoiler
image.png
SOLVED_Challenge_410_start_file.yxmd
Reply
0 Likes
AGilbert
11 - Bolide
‎03-13-2024 06:11 PM

Multi-row running total on text in 'Product ID' to build groupings for cross-tab/transpose pairs.

 

Had to re-lookup how to deal with serial dates. 

 

Spoiler
Screenshot 2024-03-13 180451.png
Challenge_410_ag.yxmd
Reply
0 Likes
Erin
11 - Bolide
‎03-29-2024 10:19 PM

Wow I went a totally different route to line this stuff up, but still got the same answer! The route I took might be for the more visual thinkers vs fancy formula parsers...

challenge_410_submission_EM.yxzp
Reply
0 Likes
AaronSmatta
8 - Asteroid
‎04-03-2024 04:10 PM

With Macro

Reformat Macro Iterative.yxmc
Challenge_410_start_fileAT.yxmd
Reply
0 Likes
adamweaver39
9 - Comet
‎04-11-2024 10:35 AM
Spoiler
challenge 410 - alteryx flow.jpg
Challenge 410 - workflow.yxmd
Reply
0 Likes
vicakram
7 - Meteor
‎05-09-2024 10:22 AM

My solution

Reply
0 Likes
vicakram
7 - Meteor
‎05-13-2024 09:29 AM
Spoiler

Weekly Challenge- 410.png
Challenge_410_MySolution.yxmd
Reply
0 Likes
Bobbyt23
13 - Pulsar
‎05-14-2024 09:43 AM

Absolutely loads going on in this one, great challenge. Had to look at the solution for help to get started.

Weekly Challenge 410 14-05-24.yxzp
Reply
youchun
6 - Meteoroid
‎05-16-2024 01:40 AM

Interesting challenge!

Challenge_410_start_file.yxmd
Reply
0 Likes
fesrimo
8 - Asteroid
‎05-25-2024 05:54 PM

The Weekly Challenge was very intereting, took me around 16 hours to complete them from 410 to 418.

My solutions for challenge Weekly #410

Ric+Challenge_410_start_file.yxmd
Reply
0 Likes