ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2025 Day 3 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

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

45 RESPOSTAS 45
martinson
Bólide
Saqueador
martinson_0-1765199652173.pngmartinson_1-1765199663830.png

 

Cheers,
martinson

LinkedIN

Bulien
mkeiffer
11 - Bolide
11 - Bolide
Saqueador
Screenshot 2025-12-08 at 5.52.48 PM.png

Saqueador
Screenshot 2025-12-08 at 5.53.00 PM.png

Day 3 solution!   I think I could have made that iterative macro more concise but it did give me the right answer.

This one was interesting; I used iterative macro as well :) 

Saqueador
day3.png
Saqueador
day3 macro.png
mceleavey
17 - Castor
17 - Castor

Catching up on posting some of these...

 

Saqueador
mceleavey_0-1765445624776.png

First, determine the length of the string, give it a recordID then parse to rows on every character. Then give it another recordID as battery position.
The iterative macro is as follows for both parts:

mceleavey_1-1765445870965.png

This basically calculates how many batteries need to be selected, so the next/first battery must leave at least enough to select the rest. This means if I need two batteries I can't start in the last position, so I can select the max from the first to the second last. Repeat with any number of batteries.
Iterate to the next run to select the max from the remaining batteries.



Bulien

abe_ibanez
Bola de fogo
Saqueador
abe_ibanez_0-1766337782279.png

 

anthonymiv
Meteoroide

Absolute Beefer

 

Saqueador
anthonymiv_0-1767893153751.png

 

Saqueador
anthonymiv_1-1767893183312.png

 

Rótulos
Autores com maior número de soluções