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 #93: Pumpkin Production

Steven_Pocoroba2
アステロイド

improved

neilgallen
クエーサー

As someone that does not care for pumpkin anything, this one was still interesting.

MattKing
アステロイド

 

Hi, here is my solution

tcroberts
クエーサー

Here's my solution

 

スポイラ
WC93workflow.PNG
It's not particularly elegant, and I'm pretty sure its possible to do with only a single join. TextToColumns to split the lookup and then a RegEx to allow conversion of production numbers to integers was key to this one.
danilang
19 - Altair
19 - Altair

I ended up with a XMAS tree on it's side with the result as the star

スポイラ
Solution 93.png

Dan

danilang
19 - Altair
19 - Altair

My solution

スポイラ
Solution 102.png

Dan

Carlithian
11 - Bolide
11 - Bolide

Here's my solution


Happy Alteryxing
willstom1
アステロイド

Here is my solution:

 

スポイラ
Alteryx Challenge 93 Solution.PNG
Wouter
アステロイド

My solution:

スポイラ
challenge 93.jpg
EFran
メテオール
スポイラ
Sol.png