Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #400: A Thanksgiving Challenge to Keep You Occu-pied

Chris-Nienart
8 - Asteroid

That was a good refresher on spatial objects!

 

Hint on how to create the Route field in Task 4

 

Spoiler
Create the line segments by putting all the spatial object points for each route associated with a bakery into a single row.
Then do a transpose on the centroids, keeping RouteID and sequence number.
Lastly, create the polyline with the poly-build tool.
 

Transpose configurationTranspose configuration

  
Watermark
12 - Quasar
12 - Quasar

Got to do what you got to do when you don't have data aligned with questions asked.  Thanks to @Kenda  for the bakeries, it was still bit of a shake & bake  😉 to fake the challenge, hope I got close to what you were going for. 

 

Spoiler
MT_Solution_400.jpg

Yoyocuter
6 - Meteoroid

My solution based on Kenda's bakery data

Qiu
21 - Polaris
21 - Polaris

@Kenda 
Thank you so much for sharing the data.
At least we can have an idea.
btw, nice challenge idea.

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution. 

 

I made this workflow based on the data provided by @Kenda . Thanks to @Kenda 

 

Spoiler
20231122.png

Flo_P
9 - Comet
Spoiler
My solution with the bakery set provided by Kendra
image.png
alexnajm
17 - Castor
17 - Castor

Same issue with the data, so worked with Kenda's file and got something!

Spoiler
Challenge 400.PNG
PhilipMannering
16 - Nebula
16 - Nebula

My solution to a different challenge - a route from Home to 1 decoration store and multiple cake shops... ¯\_(ツ)_/¯

 

Spoiler
image.png

 

 

nSpire
9 - Comet
Spoiler
400-1.png400-2.png400-3.png400-4.png
Dev73
8 - Asteroid

Uploading incomplete solution because bakery data is not available 

Spoiler
solution 400.png