Discussion thread for day 2 of the Advent of Code - https://adventofcode.com/2024/day/2
Part 1 yeah this is going to be fine.
Part 2- Like a frying pan to the face. Finally mangled my solution out though.
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.
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!
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.
Day 2 solved with a some manual checks
It is just Day 2 and it already is a already a head scracher 😅
MAIN WORKFLOW:
MACRO:
Non macro solution
Original code of all solutions here: SeanAdams10/AdventOfCodePython: Advent of code challenges in Python - across multiple years
Keep a cool head is very important during the process. 😁
You ever had that moment when creating a macro and you realized you accidentally developed a brute force copy paste solution for the problem...
Day 2! Solution is definitely going to need to be refactored because *** ew, Part 2 is embarrassing *** but I know it can easily be done with a macro... Here's a picture of the "before" while I decide how motivated I am to create an "after"!
Today's "new Designer feature shout out" definitely goes to the new Expression Editor in the Multi-Row Formula tool, and the Group By option in Record ID! ❤️
Not elegant in any way, but it works without a macro.
Took the ones that failed the first round, created the combinations of eliminated records, and redid the same analysis from part 1
Yay! finally figured out a batch macro - had to do an 8 filter solution first to understand how it should work - but got it!!!
Took me far too long to discover the gaps in my logic!
Day 2 done!
Yeah go for macro. Only proud part is I tried to use min and max, doing too much SQL recently, using metadata information is quick and less costly to read whole table and compute row by row, better for parallelism as well.
Forgot to post yesterday!--solving right at midnight isn't the best for remembering little things like that...
Well i needed some hints on part 2 as well
Tried without a macro
Sol1:
Sol2:
It's iterative macro time, it's iterative macro time! Iterative macro with a Multi-Row! Iterative macro with a Multi-Row!
Oh boy been a few months without Alteryx but getting back to it..... SLOWLY
Was a little more tricky yesterday, but mainly cos I refused to make a macro this early
Got my two stars! (not the best solution, but worked)
Part 1. A mess, but worked.
Part_2: A iterative inside a Batch macro. A triple mess, almost didn't work.
Batch
iterative
Marcus Alvim
Cool way to use an iterative macro.
Oof, day 2 and already making a macro. Probably could have managed without, but trying to get ready for an advanced recert exam
