Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
Live Weekly Challenge