Advent of Code 2023 Day 5 (BaseA Style)

[AlteryxCommunityTeam]

Discussion thread for day 5 of the Advent of Code - https://adventofcode.com/2023/day/5

[Yoshiro_Fujimori]

With a hint from @gawa , I could not come to the solution of Part 2 before going to bed.

This morning I found a way and it worked.

Thanks @gawa (and my good sleep)!

Spoiler

Main

Prep Macro

Mapping Macro

[DaisukeTsuchiya]

I revisit my WF and update. I got the clear picture now. WF completes in 0.7sec.

Spoiler

<WF>


<Macro Part1>

<Macro Part2>

[estherb47]

My brain definitely hurts after this one......

[Carolyn]

Solved. Part 1 worked beautifully but Part 2 failed spectacularly (those Joins seemed like such a good idea during Part 1), so I ended up rebuilding the workflow just for Part 2 with an Iterative Macro (which I probably should've done in the first place). Good fun

Spoiler

 

 

 

[FrederikE]

Pure brute force. The workflow ran all night and finished 20 min before the AoC Day ended. 

Spoiler

 

5/5 so far. 

[cgoodman3]

Spoiler

Brutal
Tried to brute force part 2, then spend a crazy amount of time trying to optimise.
Finally in the evening attempted the approach of creating ranges with big jumps, and then finding the seed number and then doing +1 increments around this value, which resulted in a fast solve.


And yes I probably have should have put this in a macro!

[Pang_Hee_Choy]

Spoiler

workflow

macro for part 1

macro for part 2:
1. split to group based on the seed range
2. update the destination, source, and range
3. go for next soil etc.

i did not update the previous range, because it not required.

[AkimasaKajitani]

My solution.

Spoiler

I completed part 2 just before sleeping. This is that workflow.

To be the honest, I was going to do debug more time, but I got the correct result. Some of this is not clear to me, but I'll leave it at that for now. But the workflow above is messy, so I remade it using Iterative macro.

Part 1 is normal brute force. But that was not working for Part 2. So I made it using range approach.

Part 1 macro :

 

 

Part 2 macro :

[mceleavey]

I did it.

I now hate the world.

[JarrodT]

Day 5 Part 2 was tricky even with the right "logic". Ranges are easy to conceptualize, but a bit harder to implement... but when it finally works, it solves both parts in 0.6 seconds. 😁 

Spoiler