In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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 #14: Warehouse Distribution

m-wolters
8 - Asteroid

My solution

MariusNikiforovas
8 - Asteroid

Fun challenge and a great way to practice configuring multi-row formulas: 

Spoiler
MariusNikiforovas_0-1653220637413.png

 

pgilderhus
6 - Meteoroid
Spoiler
pgilderhus_0-1653501694776.png

 

psampaio005
8 - Asteroid

Tried to do it with a iterative macro. It gave a little headache but It is finally done.

Spoiler
#14_Pedro_Sampaio.JPG
Jeremy
8 - Asteroid

Having trouble with controlling the iterations in the macro, but when I use the AMP engine, it completes in less than a second anyway, so I'm calling it good for now.

Spoiler
2022-05-30_13-27-28.png2022-05-30_13-28-08.png
mmontgomery
11 - Bolide
11 - Bolide

Challenge #14

EvanGarb
7 - Meteor

Challenge 14

Abiramm1
8 - Asteroid

Solved without a macro might try the other way :)

db
7 - Meteor

My solution

Spoiler
14.JPG

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1655127231378.png

 

Opened this one up for some macro practise before quickly realising that I could do it easily without.