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 #113: Interpolating Spatial Grid Values

Kenda
16 - Nebula
16 - Nebula
Spoiler
The Append Fields tool was the key for me here!

Capture.PNG
RolandSchubert
16 - Nebula
16 - Nebula

My solution. Decided to use a spatial approach.

 

Spoiler
20-06-_2019_14-20-24.png
MarosS
6 - Meteoroid

My solution:

TimothyManning
8 - Asteroid
Spoiler
113. Spatial.PNG


Really enjoyed this challenge! Getting much better with the spatial tools now. I tried a batch macro for each 0 row, but realised I didn't need it in the end.
fmeo
8 - Asteroid
 
Martyn
9 - Comet

This was an interesting one. I'm sure I could just have written a combination of multi-row and multi-field formulas to arrive at the same conclusion - but that would have defeated the object of using the spatial tools.

 

Not the most elegant solution, but it works!

 

Spoiler
clipboard_image_0.png
Eleonora
8 - Asteroid

Very nice challenge. Used Grid tool for the first time.

Spoiler
challenge 113 solution Eleonora Nazander.JPG
Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 113 is done!

 

Spoiler
challenge 113 JMS solution.PNG
OllieClarke
15 - Aurora
15 - Aurora

🙂

Spoiler
Challenge 113.PNG

 

TonyA
Alteryx Alumni (Retired)

This was fun. I had a hard time at first picturing how to do this with spatial tools. But once I figured out a way to do it, it was easier with spatial than by identifying and averaging cells based on column and row numbers.