Advent of Code 2025 Day 3 (BaseA Style)

[AlteryxCommunityTeam]

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

[martinson]

Spoiler

[mkeiffer]

Spoiler

 

Spoiler

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

[nikolinamilincevic]

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

Spoiler

Spoiler

[mceleavey]

Catching up on posting some of these...

Spoiler

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:

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.