Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #113: Interpolating Spatial Grid Values

Highlighted
17 - Castor
17 - Castor

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

 

Spoiler
Solution 113.png

Dan

Highlighted
Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_113_spoiler_KO.png
Highlighted
8 - Asteroid
 
Highlighted
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)

Highlighted
8 - Asteroid

Here is my solution

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

That was a very interesting and unique challenge!

Spoiler
challenge_113.PNG
Highlighted
11 - Bolide

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
Highlighted
8 - Asteroid

Hi! Here my solution :)

Highlighted
8 - Asteroid

My solution