Advent of Code 2020 - BaseA Style (Day 16)
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Discussion thread for day 16 of the Advent of Code : https://adventofcode.com/2020/day/16
- Labels:
- Advent of Code
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It's not going to win any awards for beauty, but it got across the finish line.
Iterative Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Nice to be back in a comfortable Alteryx area...
with an inner macro to do the allocaion:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was a good one, a little bit needle in a haystack finding the matches but it was satisfying when I worked out the approach to pairing of rules and ticket parts. And yes its nice to be back in Base A!
Macro:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Day16!
Today's workflow is far from elegant.
Possible Column Position Calculator Macro :
Outer Macro: Grouping by each Field Name
Inner Macro: Join Field is overwrited by Control Parameter.
Search Correct Field macro: Find count 1 Field.
AS anonymous user #1105310
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ran out of steam on Sunday so am missing a few days, trying not to look at the threads in detail but it looks like I missed some trickier ones!
Anyway nice to be back involved, here's my tidied up solution with an iterative macro to whittle down the field name/column numbers.
 
 
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Macro-free solution (with annotations) below. Runs in 2 seconds but certainly a lot of tools.......!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was much better than yesterday's 😅
My solutions so far: https://github.com/dsmdavid/AdventCode2020
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Like @Steph_Maddrell's solution, macro free. Lots of tools, but fast 1.6 seconds for both parts
Ugly but fast.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Very messy but gets the job done. It made sense when I was building it, but I used way too many tools.
