General Discussions

AlteryxMatt

Discussion thread for day 4 of the Advent of Code - https://adventofcode.com/2025/day/4

Matt Rotundo
Alteryx Community Moderator

EKasminsky

I got part one figured out. I initially saw that map and thought I couldn't ever figure it out but I did!

Part 2 maybe later if I have time and learn macros better?

mceleavey

Trying to remember what I did when posting these days later. I'm old.

Spoiler

The first section is simply creating a row ID then Tokenising to rows on all characters, then giving a column ID and removing the non-"@" characters.

Part One - Straightforward. I simply created the associated Row/Column reference for every cell (3 above, 2 on the same row, 3 below) and joined these associated cells back to the cell in the main stream. The join removes any cells that are not valid (either don't exist or are not @ cells).
I then simply counted the associated cells and created a formula: if [Count]<4 then 1 else 0 endif. This was then summed to give the answer.

Part Two: More complicated and I definitely overthought this.

The first part of the Iterative macro did almost the same as part one but would remove the rolls from the first run, then iterate around to the next run with those rolls removed. It would then determine the number of changes and the number of changes that run. Once the number of changes that run had dropped to zero the running total of number of changes was output.

The first section is simply creating a row ID then Tokenising to rows on all characters, then giving a column ID and removing the non-"@" characters.Part One - Straightforward. I simply created the associated Row/Column reference for every cell (3 above, 2 on the same row, 3 below) and joined these associated cells back to the cell in the main stream. The join removes any cells that are not valid (either don't exist or are not @ cells).I then simply counted the associated cells and created a formula: if [Count]<4 then 1 else 0 endif. This was then summed to give the answer.Part Two: More complicated and I definitely overthought this. The first part of the Iterative macro did almost the same as part one but would remove the rolls from the first run, then iterate around to the next run with those rolls removed. It would then determine the number of changes and the number of changes that run. Once the number of changes that run had dropped to zero the running total of number of changes was output.

M.

BobbyHan

I'm quite new to the world of remote work, but recently I discovered madcash.pro while browsing for reliable info about online earnings. The content feels real, not just promises or hype. There are guides for total beginners, and that’s exactly what I needed. Maybe you’ll find something helpful there as well.