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

cgoodman
ACE Emeritus
ACE Emeritus

Without a macro for this one:

Spoiler
Challenge 14.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
DiegoParker
10 - Fireball

I must say I didn't know how to do this with a macro so I just used a few multi-rows.

RobertoEstrada
8 - Asteroid

Here is my solution. Probably not the best so I need to continue practicing a lot the use of the different tools available.

Cory_Snook
6 - Meteoroid

Messy but effective.

Spoiler
challenge14.png
NoraW
7 - Meteor

Tried out the iterative macro approach...

 

Spoiler
Macro.PNGMain workflow.PNG

 

echuong
8 - Asteroid

A little bit of a different approach than the posted solution...the instructions didn't say to allocate products to stores that didn't have a requirement, so my answer differs a little

jagdeep_singh85
8 - Asteroid

PFA my solution

Lily_Unsworth
8 - Asteroid
 
joemkcarr
8 - Asteroid

Done with a batch and an iterative macro to practise

Asal
7 - Meteor

This is mine,still thinking if I can replace  a formula instead of Running Tool+ Multi-Field Formula!