Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #15: Warehouse Shipped Miles

Luke_C
17 - Castor
Spoiler
Challenge015.PNG

Nicholas_Norton
8 - Asteroid
Spoiler
snaps56_0-1614814805352.png

 

Quite a long distance to travel, but a fun challenge! 

LauraS1225
6 - Meteoroid

Attached is my solution. Spatial is something I had NEVER touched before so I struggled quite a bit here.

Tyro_abc
11 - Bolide

Tyro_abc_0-1615215072230.png

 Best Regards

Arundhuti

cchandler21
Alteryx Alumni (Retired)

See solution attached!

Daniel_Griffith
7 - Meteor

Done!

 

Using 'Find Nearest' would have saved quite a few steps!

thaodinh95
8 - Asteroid

This is a fun and sweet challenge for a beginner like me in spatial skills. 

  • I first create points for both stores and warehouse
  • Use Find Nearest tool with T as stores and U as warehouse to find the nearest warehouse for each store
  • Join the nearest warehouse output with the item file
  • Use nearest distance value in the nearest warehouse output * Assigned quantity
  • Summarize tool for item and total distance
JoaoTiagoP
Alteryx
Alteryx

My solution. 

mdsalmankhan89
8 - Asteroid

still getting used to solving spatial problems.. here is my solution .. 

AllexJia
8 - Asteroid

My solution is a little bit complicated```

Spoiler
AllexJia_0-1616552073125.png

Find Nearest Tool can make the process more somple