Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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.

SUBMIT YOUR IDEA

Challenge #113: Interpolating Spatial Grid Values

Laurap1228
11 - Bolide

This was tough:

Spoiler
Laurap1228_0-1629392966402.png

 

IraWatt
17 - Castor
17 - Castor

Very nice challenge, took me a while. 

 

Spoiler
IraWatt_0-1629728108309.png

 

JasonHu
8 - Asteroid

Here is my submission.

Spoiler
workflow.png
MichaelPilotFreight
8 - Asteroid

Check out my solution!

Qiu
21 - Polaris
21 - Polaris
Spoiler
Challenge_113.PNG
davidhardister
8 - Asteroid

davidhardister_0-1641584385835.png

 

leozhang2work
10 - Fireball
Spoiler
113.png

Not entirely sure about the spatial part, so did with join filter.

Watermark
12 - Quasar
12 - Quasar
Spoiler
MT Solution 113.png

fvojtesek
8 - Asteroid

My solution.

ARussell34
8 - Asteroid

Used a grid to create a column and row value for that section of the grid for the map layout. Used spatial find nearest tool to identify the 8 closest values to a null value to replace with an average. Identified two locations where existing in the top row and bottom row of the grid only needed 5 values that were the closest to  each grid to identify the value. Used a union tool to bring it all together and a crosstab to organize the columns values to be the new column headers and have the final output grid with all updated values.