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. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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

47 REPLIES 47
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
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

MeganBowers
Alteryx Alumni (Retired)

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
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
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
16 - Nebula
16 - Nebula

catching up from the weekend

 

Spoiler
OllieClarke_0-1670239353195.png
Labels
Top Solution Authors