We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2024 Day 2 (BaseA Style)

MeganBowers
Alteryx Community Team
Alteryx Community Team

Discussion thread for day 2 of the Advent of Code - https://adventofcode.com/2024/day/2

80 REPLIES 80
grossal
15 - Aurora
15 - Aurora

I was missing a true tool golf solution ... so I had to create one. Here it is:

 

Spoiler
2024-12-02_15-42-47_AlteryxGui_Alteryx_Designer_x64_-_New_Workflow2.png

 

Formulas are a little too short and the bar is a little to high for Obscura, but they look nice anyway.
JS1989
8 - Asteroid

Solution

Raj
16 - Nebula

part 1 
kept it simple and working.

Bobbyt23
13 - Pulsar

Part 1 yeah this is going to be fine.

 

Part 2- Like a frying pan to the face. Finally mangled my solution out though.

Spoiler
image.png
peter_gb
10 - Fireball

Generate rowwwws, no macro yet. I really should have been able to think of a fancy regexy thing but couldn't, happy with my solution and solve time though.

Spoiler
Brute force for each level, created all possible 1 digit omissions and then copy and pasted my part one tools to test them all out.  Not mega elegant, not mega messy.
AoC_2024_2_pgb.png

JeffF
Alteryx
Alteryx
Spoiler
Day02-JeffF.png
binuacs
21 - Polaris
Spoiler
image.png
JHendu
Alteryx
Alteryx

Day 2 in the bag. Let's go! I'm pretty proud of my solution for part 1...more or less all crammed into one formula tool! Part 2 got a little messy, but it worked!

 

Spoiler
Day2_Part1.pngDay2_Part2.png

 

Carolyn
12 - Quasar
12 - Quasar

FINALLY! I spent so long trying to solve Part 2 without a macro and ended up with a huge mess of tools. I was close but missing 2 records (based on what the eventual solution was). I finally gave up and built an Iterative Macro to mass test each group by removing one line at a time. 

 

Spoiler
2024-12-02_12-07-08.png

 

2024-12-02_12-07-18.png
Shelbey
Alteryx
Alteryx
Spoiler
Screenshot 2024-12-02 121900.png

 

Labels
Top Solution Authors