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
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 #14: Warehouse Distribution

JoshuaGostick
12 - Quasar
‎02-25-2019 06:45 AM

Went for the non-macro route.

Spoiler
challenge_14.PNG
challenge_14_JG.yxmd
Reply
0 Likes
BenMoss
ACE Emeritus
ACE Emeritus
‎02-27-2019 06:11 AM

Didn't feel the need to complicate it with macros! TOOLNAMEHERE FTW!

challenge_14_SolutionBM.yxmd
Reply
0 Likes
Jonathan-Sherman
15 - Aurora
15 - Aurora
‎02-27-2019 07:45 AM

Challenge 14 is done!

Spoiler
challenge 14 JMS solution.PNGchallenge 14 JMS solution formula.PNG
challenge_14_JMS_solution.yxmd
Reply
0 Likes
hanykowska
11 - Bolide
‎02-27-2019 08:08 AM

Finally, done

challenge_14_solution_hanykowska.yxzp
Reply
0 Likes
JacobR77
8 - Asteroid
‎03-04-2019 06:55 AM

Not quite an answer to this challenge, but if anyone wants to learn a little about iterative macros, I've attached a packaged workflow that makes use of them.

 

 

TrustPilot Webscraping.yxzp
Reply
0 Likes
IJReed
8 - Asteroid
‎03-05-2019 06:39 AM

👍

challenge_14_start_file - Solution.yxzp
Reply
0 Likes
hugolees
7 - Meteor
‎03-06-2019 07:38 AM
 
challenge_14_solution.yxmd
Reply
0 Likes
princejindal
9 - Comet
‎03-09-2019 03:24 AM

Very interesting challenge, thank you!

Reply
0 Likes
HuwHallam
8 - Asteroid
‎03-11-2019 07:26 AM

Got to an answer using the multi-row formula tool. I tried sooooo hard to craft an iterative macro for it, but just couldn't get my head around how (I'm new to them). Time to look at what others have done and learn! :)

challenge_14_HH.yxmd
Reply
0 Likes
alyssa_sedai
9 - Comet
‎03-13-2019 02:10 PM

Here's what I got

Challenge 14.yxmd
Reply
0 Likes