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

Nebula
Nebula

A non-spatial solution for me.  I'll have to come back and try the spatial route

 

Spoiler
Solution 113.png

Dan

Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_113_spoiler_KO.png
Asteroid
 
Alteryx Certified Partner

Fun one :-)

I use a buffer around the 0 values & then spatial match (touch or intersect), to avoid problem when the missing value is located on the edge (even if not the case in this exercise)

Asteroid

Here is my solution

Alteryx Certified Partner

Here's my solution - enjoyed this one.

 

Spoiler
Not sure if I made things harder for myself by not using the spatial tools, but I didn't see the value in this case.

Screenshot 2018-12-27 at 22.08.51.png

Approach based on the below rough notes made when I first examined the problem:

Screenshot 2018-12-28 at 15.28.15.png

Always feels like an easier task once I've got the logic written out, but maybe that's just the way my brain works!
Alteryx Certified Partner

That was a very interesting and unique challenge!

Spoiler
challenge_113.PNG

This was a fun one, and not too tough. It had a little bit of spatial, a little bit of data prep, and a little bit of data reshaping!

 

Spoiler
I was going to do this using sequential row and column numbers, but figured that I should use a spatial tool since this is a spatial challenge!

challenge_113_workflow.PNG
Asteroid

Hi! Here my solution :)

Asteroid

My solution