In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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

siddharth_28
8 - Asteroid
‎02-15-2023 07:26 AM

Re: Challenge #14: Warehouse Distribution

challenge_14_start_file.yxmd
Reply
0 Likes
OJohn
5 - Atom
‎02-16-2023 04:16 AM

Have worked through this with a nested Batch and Iterative Macro.

Spoiler
OJohn_0-1676549331453.pngOJohn_1-1676549350650.pngOJohn_2-1676549376027.png

 

 

 

Itterative.yxzp
Batch.yxzp
challenge_14_oj.yxmd
Reply
0 Likes
akorte1
8 - Asteroid
‎02-20-2023 11:59 AM

Done

Reply
0 Likes
jerviss53
8 - Asteroid
‎02-22-2023 04:34 AM

Solution attached

Challenge_14_solution.yxzp
Reply
0 Likes
CeliaC_Silje
8 - Asteroid
‎02-23-2023 10:41 PM
Spoiler
hycheungal_0-1677220854209.png

Prefer using the straightforward way in this challenge although Iterative Macro surely helps.

challenge_14_start_file.yxmd
Reply
0 Likes
Keppatawn
8 - Asteroid
‎02-27-2023 08:49 PM
Spoiler
Keppatawn_0-1677559726576.png

 

challenge_14_kpt.yxmd
Reply
0 Likes
isabelcc
8 - Asteroid
‎03-01-2023 10:51 AM
Spoiler
14.png
challenge_14_IC.yxmd
Reply
0 Likes
Daniel1127
8 - Asteroid
‎03-02-2023 03:48 AM

Solution as attached. 

 

 

challenge_14_start_file.yxmd
Reply
0 Likes
Amilley
8 - Asteroid
‎03-07-2023 03:26 PM

I did not go the loop via an iterative macro, but the multi-row tool was a big help:

 

Amilley_0-1678231527343.png

 

challenge_14_Solution_03.07.2023.yxmd
Reply
0 Likes
Spurs
8 - Asteroid
‎03-09-2023 03:29 AM
Spoiler
Spurs_0-1678361347649.png

 

challenge_14_Finished.yxmd
Reply
0 Likes