Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2020 - BaseA Style (Day 16)

Jean-Balteryx
16 - Nebula
16 - Nebula

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

10 REPLIES 10
Greg_Murray
12 - Quasar

It's not going to win any awards for beauty, but it got across the finish line.

Spoiler
Workflow
Greg_Murray_2-1608100135462.png

 


Iterative Macro

Greg_Murray_1-1608099956236.png

 

jdunkerley79
ACE Emeritus
ACE Emeritus

Nice to be back in a comfortable Alteryx area... 

Spoiler
jdunkerley79_0-1608105973897.png

with an inner macro to do the allocaion:

jdunkerley79_2-1608106018358.png

 


 

Balders
11 - Bolide

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!

 

 

Spoiler
Workflow:

AoC 16p2.png
Macro: 
AoC16 macro.png

 

 

AkimasaKajitani
17 - Castor
17 - Castor

Day16!

 

Today's workflow is far from elegant.

 

Spoiler
AkimasaKajitani_0-1608122872226.png
Possible Column Position Calculator Macro :
Outer Macro: Grouping by each Field Name

AkimasaKajitani_3-1608122992613.png

 



Inner Macro: Join Field is overwrited by Control Parameter.
AkimasaKajitani_2-1608122943310.png

 

Search Correct Field macro: Find count 1 Field.
AkimasaKajitani_4-1608123289461.png

 

 

AS  anonymous user #1105310

https://github.com/AkimasaKajitani/AdventOfCode

peter_gb
9 - Comet

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.

Spoiler
16.png

16_1.png

 

Steph_Maddrell
8 - Asteroid

Macro-free solution (with annotations) below. Runs in 2 seconds but certainly a lot of tools.......!

 

 

Spoiler
stephM_3-1608136254428.png

 

 

dsmdavid
11 - Bolide

This was much better than yesterday's 😅

Spoiler
Alteryx_Day_16.png

My solutions so far: https://github.com/dsmdavid/AdventCode2020

danilang
19 - Altair
19 - Altair

Like @Steph_Maddrell's solution, macro free.  Lots of tools, but fast 1.6 seconds for both parts

 

Spoiler
danilang_0-1608142515799.png


Ugly but fast.  

 

patrick_digan
17 - Castor
17 - Castor

Very messy but gets the job done. It made sense when I was building it, but I used way too many tools.

Spoiler
patrick_digan_0-1608173904169.png

 

Labels