Advent of Code 2020 - BaseA Style (Day 6)

[Jean-Balteryx]

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

[Steph_Maddrell]

Oh so many summarise tools!

Spoiler

I took a slightly different route to others as I didn't think to use the regex tool to parse to rows 🤔

[jdunkerley79]

Pretty Much Identical To @NicoleJohnson solution...

Spoiler

[OllieClarke]

Here's my day 6 solution. I had fun learning some new RegEx to get my group tokenising to work 🙂

Spoiler

[Jean-Balteryx]

Similar to some solutions !

Spoiler

[stevea]

So many summarize, so little time.  See how much accidental complexity I have means it's time to refactor...

Spoiler

[danilang]

So well suited to Alteryx.

It's almost like the AoC puzzle elves heard us griping last year.  Or maybe one of our AoC++ friends slipped a little rum into the puzzle elves' eggnog.

Spoiler

 Dan

[patrick_digan]

I solved it using BaseA (not as efficiently as others), and then got part2 down to 3 tools NON BaseA using @jdunkerley79 's alteryx abbacus (plus the varnnumadd function which I don't think I've pushed to his repo yet). My 1 formula tool is a little verbose, but the variable functions are pretty powerful. It's not fully dynamic in that I had to hardcode my last line (otherwise I would have to add another tool). I'm basically just using a flag for each letter and turning it off each time somebody in the group doesn't have that letter.

[cgoodman]

@Steph_Maddrell here is a trick for generating the letters a - z without needing the write them out (and risk a mistype).

#HappyFestiveSolving

[NedHarding]

Again - probably better suited to Alteryx than a "normal" programming language.  Wondering how long that will last?

Spoiler

[jdunkerley79]

@cgoodman : why not just go for the generate rows: