In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more 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 Alumni (Retired)

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
binu_acs
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