community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #113: Interpolating Spatial Grid Values

Pulsar
Pulsar
Spoiler
The Append Fields tool was the key for me here!

Capture.PNG
Alteryx Certified Partner

My solution. Decided to use a spatial approach.

 

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

My solution:

Highlighted
Alteryx Certified Partner
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.
Asteroid
 
Asteroid

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
Asteroid

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

Spoiler
challenge 113 solution Eleonora Nazander.JPG
Alteryx Partner

Challenge 113 is done!

 

Spoiler
challenge 113 JMS solution.PNG
Alteryx Partner

Spoiler
Challenge 113.PNG

 

Alteryx
Alteryx

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.