Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2022 Day 8 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Discussion thread for day 8 of the Advent of Code - https://adventofcode.com/2022/day/8
21 REPLIES 21
grossal
15 - Aurora
15 - Aurora

Part 1 was pretty straightforward, and Part 2 was in my mind as well. Took a lot of debugging to find my mistake. Anyhow. Finally securing a Part 2 win :-)

 

Spoiler
grossal_0-1670479315312.png

 

 

bflick
8 - Asteroid

Brute force or bust for part 2. Tracking down bugs in large conditional if statements will always be the bain of my existence

Spoiler
bflick_0-1670479743455.png

 

AkimasaKajitani
17 - Castor
17 - Castor

I went to brute force approach.

 

Spoiler
AkimasaKajitani_0-1670481447027.png

Part 1 macro:

AkimasaKajitani_1-1670481481822.png
Part 2 macro:
AkimasaKajitani_2-1670481506769.png

 

 

clmc9601
13 - Pulsar
13 - Pulsar

This one didn't click for me. Struggled for a long time before coming up with a clunky solution. As I cleaned it to post here, turns out half of it was unnecessary 😣😂 

 

Spoiler
Part 1: sorting the coordinates four times so all directional calculations are executed from the top down
Screen Shot 2022-12-07 at 11.54.16 PM.png



Part 2: appending each tree to the rest to calculate the tree's scenic distance in all four directions. The macro only iterates 99 times, thankfully.

Screen Shot 2022-12-07 at 11.56.50 PM.png

 

DawnDuong
13 - Pulsar
13 - Pulsar

I overcomplicated things for part 2 and that costed a lot of times.

Spoiler
Part 1 is relatively straightforward, I used a lot of Multirow tools to make it easier to debug.
DawnDuong_1-1670483878724.png

Part 2 is, upon hindsight, not that complicated had I not overcomplicated things.

DawnDuong_2-1670483943405.png

 



Used a "brute force" macro, similar to what others had posted earlier.
DawnDuong_0-1670483788599.png
Jean-Balteryx
16 - Nebula
16 - Nebula

Day 8 done ! ✔️

 

Here is my monster ! Not sure it's worth explaining as it should have a disclaimer "Don't do that at home, it has been performed by professionals." !

 

Spoiler
JeanBalteryx_0-1670493244728.png

 

balders-ie
7 - Meteor

Happy with this one today, quite clean and concise for the challenge. For both parts 1 & 2, each data stream is a different cardinal direction.

 

I've added my golf today, but happier with my first solution as it was more computationally efficient. It had more tools but ran faster due to paring down the data properly with filters!

 

Spoiler
Screenshot 2022-12-08 120334.png

 Golf:

Screenshot 2022-12-08 131757.png

 

ApekshaSharma
6 - Meteoroid

Hi All, this was my solution for Day8. :)

 

Spoiler
Day8.PNG


patrick_digan
17 - Castor
17 - Castor

Definitely not competing for tool golf today, but I didn't have too much trouble

Spoiler
I just defined each cell as a specific row/column, and then just sorted it 4 times and checked each direction independently.
patrick_digan_0-1670504869236.png

 

 

Labels