In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2025 Day 1 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

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

48 REPLIES 48
iracine
7 - Meteor

Am I too late to the party? Was flying yesterday but finally managed to get home and solve this! 

Spoiler
Capture d’écran 2025-12-02 à 10.21.18 PM.png

 

estherb47
15 - Aurora
15 - Aurora

Initially, approached this like many others, harnessing the power of the multi-row tool to find the position after a rotation, in one single line. That worked very well for part 1, but I was having trouble troubleshooting for part 2

 

Spoiler
Refactored my solution to click one tick at a time around the clock, and then count up all of the times it crossed zero. For part one, just needed to also filter for the final click for each rotation.

The Multi-Row tool has the magic. Subtract one for the L moves, and add one for the R. When crossing zero with an L move, start subtracting from 100. Mod 100 on the whole formula to take care of the values over 100 (yes, I could have restarted at 0 moving to the right, but that would have added yet another ELSEIF

estherb47_0-1764733292474.png

 

Qiu
21 - Polaris
21 - Polaris

I was lost in the if else statements...

Spoiler
AoC 2025 Day 01.png
Kanishkas5301
8 - Asteroid

I'm late but it's nice to be back to the Alteryx Advent of Code community!

 

Spoiler
Kanishkas5301_0-1764743326364.png

 

CoG
14 - Magnetar

Started with brute force approach, then optimized with more efficient approach.

 

Spoiler
Brute Force:
Attempt 01.png
Optimized:
Attempt 02.png
Attempt 02 - Find 0s.png

The formula is complex, but all it's doing is counting the number of multiples of 100 between successive dial values (without modular calculations).

Happy Solving!

 

 

M_Enomoto
6 - Meteoroid

I'm joining AoC 2025 with Alteryx for the first time! (username in Leaderboards: Masaki Enomoto)

...wow, it's already tough starting from Day 1.

 

Spoiler
M_Enomoto_0-1764762972970.png

 

 

 

Malvim
11 - Bolide

I must be the one trying to score on 'more tools used'... 😑

 

Spoiler
Malvim_0-1764778637332.pngMalvim_1-1764778666389.png

 

Carolyn
12 - Quasar
12 - Quasar

Solved! I had some fun with mod functions for figuring out how to turn -18 into +82

 

Spoiler
2025-12-03 08_24_07-Alteryx Designer x64 - _2025 01 AoC Carolyn.yxmd.png
Laurap1228
11 - Bolide

My solution to part two works but is 1 off

Labels
Top Solution Authors