Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2023 Day 6 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

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

47 REPLIES 47
caltang
17 - Castor
17 - Castor

Did some prep work on the input as well since I was too lazy to copy each record one by one....

 

Spoiler
image.png
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
PangHC
13 - Pulsar

with one tool change for part 2. time to use detour. haha.

Spoiler
Screenshot 2023-12-06 160750.png

 

DataNath
17 - Castor
17 - Castor

Day 6 done to give a nice little serotonin boost after yesterday's part 2 breakdown! Not winning tool golf with this one but 2 stars = 2 stars.

 

Spoiler
Day6.png
Spainey
9 - Comet

Not a pretty solution, but a simple one

Spoiler
 
Day 6.png

 

SeanAdams
17 - Castor
17 - Castor

started out thinking to solve this using a quadratic formula like @CoG - but it turns out that the brue-force method runs in just a few seconds anyway, so rather spend extra time finishing Day 5...

I will go back and take a look at how others have solve this thought - just for learning.

 

Spoiler
the basic process:
- Parse the data into a table like this
Screenshot 2023-12-06 050725.png
- then use Generate Rows to generate valid combinations of hold times - here I could use math to limit the population
- Then just filter the valid ones

The only difference between part 1 and part 2 - is that in part 2 I also cleaned out the whitespace so there is only one race in this set.

Screenshot 2023-12-06 050914.png



DavidP
17 - Castor
17 - Castor

Nice easy one. Thankfully!

 

Spoiler
aoc d6.png
mmontgomery
11 - Bolide
11 - Bolide

Team brute force! 17 seconds to generate 60m records

Spoiler
Day6.png
Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My solution.

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
 

image.png

Kenda
16 - Nebula
16 - Nebula
Spoiler
Used the ol' transpose + cross tab trick @patrick_digan 

image.png
Labels
Top Solution Authors