Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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