Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2022 Day 6 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

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

51 REPLIES 51
grossal
15 - Aurora
15 - Aurora

Forgot to post mine for yesterday, but here we go! No Tool Golf today. 

 

Spoiler
grossal_0-1670415959916.png

 


 Macro: 

grossal_1-1670415971678.png

 

 

 

 

estherb47
15 - Aurora
15 - Aurora

@AkimasaKajitani , have to admit that I googled that one to get it correct. Knew it was possible, just didn't know how to write the statement

balders-ie
7 - Meteor

Ugly long formula created in notepad++ for part 2 

 

Spoiler
Screenshot 2022-12-07 230124.png

balders-ie
7 - Meteor

@DavidP nice use of the regex lookahead there. I had to put it into regexr to work out what it was doing. 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1670464793228.png

 

clmc9601
13 - Pulsar
13 - Pulsar

My python solution is much cleaner than my Alteryx solution 😂 #SnakingMyWayThroughChallenges

 

Spoiler
AoC Python Day 6.png

starkey
7 - Meteor

@atcodedog05 brilliant solution! I would never have thought to build out a regex expression that way to identify duplicates.

DaisukeTsuchiya
13 - Pulsar
Spoiler
DaisukeTsuchiya_0-1670723078346.png

 

Shelbey
Alteryx
Alteryx

I've officially made it farther in the challenge than I ever have in the last few years I've been attempting this 😁

 

Solution:

Spoiler
Shelbey_0-1671551171379.png

 

Macro:

Spoiler
Shelbey_1-1671551201196.png

 

Luckily I made the macro easy to scale :) the only difference between Part 1 and Part 2 was the number of records I was choosing with my Select Records tool and the filter requirements.

Watermark
12 - Quasar
12 - Quasar
Spoiler
AOC Day 6 MT.jpg

Think my second answer is actually simpler than the first, but wasn't going to bother to rewrite the first one. 

Labels