Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
alteryx Community

# 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.

## Challenge #113: Interpolating Spatial Grid Values

8 - Asteroid

Challenge #113 resolved

Spoiler
Workflow
15 - Aurora

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.
17 - Castor

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.

7 - Meteor

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

13 - Pulsar

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
Definitely going to apply some of these concepts to my work.
12 - Quasar

Solution attached.

15 - Aurora

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
11 - Bolide

This was a lot of fun. Thanks!

17 - Castor

Challenge Completed

16 - Nebula

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