Discussion thread for day 6 of the Advent of Code : https://adventofcode.com/2020/day/6
Day 6!
As anonymous user #1105310
Another puzzle well suited for Alteryx!
@NicoleJohnson you're too quick!
I feel like this "traveling with large groups of elves through airports" theme is kind of mocking our current world 2020 situation, particularly since I was *supposed* to be leaving for Australia in 10 days (before this dumpster fire year wrecked that plan)... but I have loved these AoC puzzles so far. So I guess you win some, you lose some? 😉
Cheers!
NJ
https://github.com/AlteryxNJ/AdventOfCode_2020
@Greg_Murray It's a struggle - I've had to convince my 6 year old to go to bed earlier than usual this month so that "Mommy can have her advent calendar too," and I think this is probably going to cause more trouble than it's worth because it turns out 6 year olds do not equate coding challenges as equivalent to chocolate, and "Because winning makes Mommy happy" is apparently not seen as a good excuse for early bedtimes... but DARN IT, I like doing Alteryx fast. ("Go to bed, child!!") 😉
You are giving me a run for my money though, I can feel you right at my heels!!
Definitely one for Alteryx. @NicoleJohnson - it doesn't get easier when the kids get older. My only kid left at home is my 17 year old daughter and she and my wife are shaming me for "geeking out over extra credit Alteryx".
@T_Willins Yeah, but you're using Christmas colors in your comment boxes! It's festive!!! Tell them to stop being such Grinches... 😉
Another challenge well suited to Alteryx. I need to look at @T_Willins solution as it's done with fewer summarise tools.
Oh so many summarise tools!
Here's my day 6 solution. I had fun learning some new RegEx to get my group tokenising to work 🙂
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.
Dan
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.
6 challenges in and still nothing too difficult. I'm starting to worry. Intcode trauma is real!
Day 6 | a nice relaxing sunday puzzle vs the binary madness
Edit - posted on wrong day catching up with solutions 🙂
After overcomplicating Day 5 with an iterative macro (my favourite), it was good to get through this one in a couple of minutes.
