Advent of Code 2023 Day 3 (BaseA Style)

AlteryxCommunityTeam

Discussion thread for day 3 of the Advent of Code - https://adventofcode.com/2023/day/3

Advent of Code

Accepted answers

All comments

Gawa

I was thinking if I could apply Spatial Analysis to this kind of X-Y coordinates problem, and come up with one.

Spoiler

Overall Work Flow looks like this.

Create X-Y coordinates, and convert them into Spatial Objects. Define the "Search Distance" based on the distance to the 2nd nearest object, When doing so, you can pick any object as a target because all objects are aligned equally. (Please note that if we don't need to care about the diagonally located neighborhood, Search Distance will be based on the distance to the 1st nearest object)
In order to avoid the issue of tiny difference in digit of double/float data, I multiply x 1.1 for sure. This allowance is reasonable as far as it does not exceed the distance to the 3rd nearest object.

With Find the Nearest Tool and "Search Distance" calculated as above, we can find the neighborhood.

AoC2023_Day3_spatial_version.yxmd

Kenda

Spoiler

found logic to get this without generating rows!

3.yxmd

AncientPandaman

build a macro for split to xy position and add adjacent. it used quite a lot in previous years.

Spoiler

Day 03.yxzp

Ladarthure

nothing fancy here, just a bit of coordinates and generating rows

03.yxmd

rachel_k

Messy and inelegant - this is clearly my first time thinking about this type of problem. Glad to see all the smarter ways everyone approached this, to learn from for the next time.