Advent of Code 2020 - BaseA Style (Day 7)

[Jean-Balteryx]

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

[NedHarding]

Similar solution to other people.  Brain not working today so had to fight through an off by 1 bug (I counted the outermost bag.)

But at least my input macro worked perfectly and saved me a few seconds...  https://community.alteryx.com/t5/General-Discussions/Advent-of-code-2020/m-p/676655/highlight/true#M...

Spoiler

 Find it at https://github.com/NedHarding/Advent2020

[danilang]

That's quite a lot of bags.  Exactly how thick at the walls of these bags...and how big are the planes

Spoiler

Dan

[estherb47]

A good iterative macro challenge to get the brain moving!

Nothing novel here, took the same building from inside out and then outside in that most did.

Spoiler

[Balders]

Quite happy with this, one iterative macro for both parts. Nothing earth shattering but re-use where you can!

Spoiler

[Aguisande]

Finally got the time to post...

Here's my approach, tried to solve both parts with the same kit of macros, until realized that I had to switch inner and outer bags for one of the parts.

So I decided to Save as.. one of the macros, modified as needed and incorporate it (easier way).

Spoiler

This is the pre-iteration macro (used for both parts):

And the two iterative ones:

(Almost identical, but with a twist in the Join Tool)

[OllieClarke]

Part 1 took me a few minutes. Part 2 took me hours to work out that had I just connected to data rather than a text input, everything would be golden 😫

Spoiler

Workflow
Part 1Part 2

[joshbennett]

This one hurt my brain a little - used an iterative macro, similar to others.

Part 1:

Spoiler

Macro:

Part 2:

Spoiler

Slightly modified macro from part 1: