ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

General Discussions

Discuss a wide range of topics! Questions about the Alteryx Platform should be directed to the appropriate Product discussion forum.

Advent of Code 2020 - BaseA Style (Day 16)

Jean-Balteryx
14 - Magnetar

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

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
16 - Nebula
16 - Nebula

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
10 - Fireball

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
14 - Magnetar

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
8 - Asteroid

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

 

stephM
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
17 - Castor
17 - Castor

Like @stephM'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
16 - Nebula
16 - Nebula

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