General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2022 Day 4 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

Discussion thread for day 4 of the Advent of Code - https://adventofcode.com/2022/day/4

43 REPLIES 43
SeanAdams
17 - Castor
17 - Castor

Here's my dirty solution for Day 4.
I'm going to redo this solution using an Islands & Gaps approach.

 

Spoiler
Full thing including inputs & tester:
SeanAdams_0-1670161699495.png



Just the final solution:

SeanAdams_1-1670161725881.png



The Regex: 

SeanAdams_2-1670161742748.png



The formulae:

SeanAdams_3-1670161811859.png

 

mmontgomery
11 - Bolide

Definitely overthought it 

Spoiler
mmontgomery_0-1670163204854.png

 


 

 

mceleavey
17 - Castor
17 - Castor

Still waiting for the questions to become beyond my tiny brain...

 

Spoiler
I did this two ways. The first using filters, the second using a simple nested IF:

mceleavey_0-1670162105697.png

The first part was just splitting the data out into the component parts.



Bulien

MeganDibble
Alteryx Community Team
Alteryx Community Team

This one was a little nicer than yesterday! I can actually see how the tool golf solution is possible lol

 

Spoiler
Screen Shot 2022-12-04 at 9.28.08 AM.png
Jean-Balteryx
16 - Nebula
16 - Nebula

Day 4 done ! 

 

It was there.

 

Spoiler
Capture d’écran 2022-12-04 à 17.51.16.png
DavidP
17 - Castor
17 - Castor

@peter_gb I did the same!!! Drove me nuts!!!

kelsey_kincaid
12 - Quasar

Got a late start today, and was maddened by how much single section groups tripped me up, but I got there eventually. Looking forward to playing "golf" with this one!

Spoiler
kelsey_kincaid_0-1670183714699.png

 

kelsey_kincaid
12 - Quasar

Oh I definitely overcomplicated it. Your solution is nice and clean!

starkey
7 - Meteor

This one wasn't too bad, just took some time thinking through the fully contained / overlap formula I went with here:

 

Spoiler
starkey_0-1670212520415.png

 

OllieClarke
15 - Aurora
15 - Aurora

catching up from the weekend

 

Spoiler
OllieClarke_0-1670239353195.png
Labels