Advent of Code 2025 Day 1 (BaseA Style)

[AlteryxCommunityTeam]

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

[AlteryxCommunityTeam]

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

[PangHC]

saw a lot of same approach. good challenge for mod function

Spoiler

- add initial line instead of manipulate multi-row. 
- use generate row to +-1 instead of complex formula.

- use mod to limited to 0-99

[matthewblandford]

Did I get lost in the weeds for a bit doing convoluted if/then statements? Yes. Will I learn my lesson for future days? Probably not!

[DaisukeTsuchiya]

The challenges on Day 1 were quite interesting.

Spoiler

P1 was solved with the Multi-Row Formula and P2 was solved by combining the Generate Rows and Multi-Row Formula tools.

[martinson]

Day 1, great fun!

Spoiler

[mceleavey]

Nice and easy to start with, and I had one of those builds where I accidentally answered part two from building part one.

Spoiler

 

I began by using regex to parse out the bits of each turn, namely the Direction letter, the last two digits (I'll come back to this) and the leftover. To do this I used the following:

I parsed the last two digits as we only need these to determine the move. 762 is the same as 62 for part one, so I simply chopped it into three:

I then used a multi-row to determine position:

This gave me the answer for Part One, and given I had split the original data into three columns, the "leftover" bit was essentially the extra clicks, given these were numbers of hundreds, which would always be an extra click per hundred, and so I simply needed another multi-row formaula to determine the number of clicks from the actual moves, then add the hundreds:

Then simply sum this column.
And Robert's your father's brother.

A nice start to AoC. Probably the only day I'll get a chance to do this, but here's hoping.

M. 

[TheOC]

Some refactoring needed for step 2 but we got there.

Spoiler

I love my multi-rows.
Filter for Part 1, summarise + filter for part 2.

[DanFlint]

Spoiler

Definitely didn't do this the most efficient way, but it works!

[Yoshiro_Fujimori]

As the approach for Part 1 did not work, I started from the scratch for Part 2, and it worked.

Spoiler

Workflow

Formula Tool #1
  [sign] = IF StartsWith([Field_1], "L") THEN -1 ELSE 1 ENDIF
  [num] = ToNumber(Substring([Field_1],1,Length([Field_1]) - 1))

[Carlithian]

Firstly shout out to @clmc9601  for he fantastic starter kit :)  Gave that a little tweak to use my own template and    @cgoodman3's  testing macro to make  this so much smoother <3

Spoiler

As always I manage to miss something in the question,   particularly the 'starting on position 50'  and I spent far too long faffing with my  multi row tool to get it to start at 50 before finally just bringing in an extra row of data.... I don't like this and will find a cleaner way when I update it down the line.

Then for some reason I thought the dial only went up to 90 not 100....so  lost a lot of time on that   😅 and that I needed to count every time the 0 position was passed.... this wasn't the case (until part two of course....)

  and

[mmontgomery]

Day1.

Spoiler

Team brute force to generate 100k rows then doing a mod logic to keep the ids straight.
P1: I macro
P2: take the results then generate more rows to account for each time a value hits 0