General Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

Advent of Code 2020 - BaseA Style (Day 16)

Jean-Balteryx
13 - Pulsar

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