Advent of Code 2022 Day 6 (BaseA Style)

[AlteryxCommunityTeam]

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

[grossal]

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

Spoiler

 Macro: 

[estherb47]

@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]

Ugly long formula created in notepad++ for part 2 

Spoiler

 

[balders-ie]

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

[Kenda]

Spoiler

[clmc9601]

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

Spoiler

 

[starkey]

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

[DaisukeTsuchiya]

Spoiler

[Shelbey]

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

Macro:

Spoiler

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]

Spoiler

 

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