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

Alteryx Certified Partner

Challenge #113 resolved

Spoiler
Workflow.pngWorkflow
Magnetar
Magnetar

Fun! Also created a spatial and non-spatial approach. I didn't know you could customize the Find Nearest tool to whatever number you need.

Spoiler
Pretty similar to other solutions. Instead of using a formula tool. dynamically renamed the column headers to start with 0. Also decided to parse out the column and row headers from the Maui grid using a RegEx parse tool, parsing method.

For the non-spatial, 2 generate row tools generated the rows and columns needed for the averages. When you match back to the non-average values, rows and columns outside the grid fall away.
image.png
Nebula
Nebula

Tackled this in a cheap-and-cheerful kinda way.    going to look at other folks' solutions next

 

Spoiler
- Transposed the data so that each sell was represented as X,Y,Value
- Then used row generators to add 9 rows for each row, which would point to the surrounding cells
- Joined to the original data set from step 1 to bring in the value (which then also filtered out values that don't exist because it's an edge piece etc)
- Summarised the average of all surrounding cells.
  
Now I have a table of:
X; Y; Value; Average of surrounding

Then it's a simple matter of replacing the value with the average if the value is zero; and then crosstabbing back in to the right format.


2018-06-03_9-27-35.png






 

 

 

Alteryx Partner

Good challenge for using new spatial tools! I did not do a non-spatial approach but love the creativity and variety of others' solutions.

Bolide

This was a fun exercise! Don't get to use the spatial tools that often. It would have also helped if I would have read the instructions and realized the distance measure was meters and not miles like my brain interpreted from "m."

Spoiler
Challenge 113.JPGDefinitely going to apply some of these concepts to my work. 
Quasar

Solution attached.

Alteryx Certified Partner

My solution, I had no idea what the goal of this was so  had to look at the solution to figure out what was required

 

Spoiler
113.PNG
Bolide

This was a lot of fun. Thanks!

Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Alteryx Certified Partner

I love that you can use find nearest to get the 8 nearest grid values, but also set a distance limit to get 5 grid values for the pieces around the edge.

 

Spoiler
Challenge 113 - Capture.PNG