Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2020 - BaseA Style (Day 3)

Jean-Balteryx
16 - Nebula
16 - Nebula

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

22 REPLIES 22
jdunkerley79
ACE Emeritus
ACE Emeritus

Day 3 - getting trickier, needed more thought

 

Spoiler
jdunkerley79_0-1606976435159.png

 

NicoleJohnson
ACE Emeritus
ACE Emeritus

I definitely am finding myself suffering from flashbacks and asking myself "How can I build this so that it is flexible enough that I can still be using it 12 challenges later?"...

 

Also, per usual, was fairly pleased with my solution until I saw @jdunkerley79 10-tool variation. Sigh.

 

Spoiler
Day3.JPG

Cheers!

NJ

jdunkerley79
ACE Emeritus
ACE Emeritus

@NicoleJohnson this one absolutely had the feeling that this won't be the last we see of the toboggan!

 

You're still top of the table 🙂

jdunkerley79_0-1606980642283.png

 

Anyone else who wants to join the league (we currently have about 32 active players) the code is 453066-ca912f80

 

Jean-Balteryx
16 - Nebula
16 - Nebula

And ... I went for the macros on day 3.

 

Spoiler
Capture d’écran 2020-12-03 à 09.03.33.png
Spoiler
Capture d’écran 2020-12-03 à 09.04.01.png
Spoiler
Capture d’écran 2020-12-03 à 09.04.19.png
cgoodman3
14 - Magnetar
14 - Magnetar

Day 3 reminds me of this

 

SQCNh1k.gif

 

Spoiler
cgoodman3_0-1606983931310.png

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
cgoodman3
14 - Magnetar
14 - Magnetar

@Jean-Balteryx how is the runtime with the batch and iterative macro? I think it was 2018 were we discovered switching from macros to generating lots of rows the run time is really fast.

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Jean-Balteryx
16 - Nebula
16 - Nebula

@cgoodman3 10 seconds, I think your solution is faster !

cgoodman3
14 - Magnetar
14 - Magnetar

It's because there were challenges in 2018 that would take 1 hour+ to run using iterations and batch macros, but using things like generate rows gets the run time down into the minutes ballpark.

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
AkimasaKajitani
17 - Castor
17 - Castor

Day 03

 

I made macro, too. But my approach is putting the part 1 workflow into macro.

Spoiler
AkimasaKajitani_0-1607004879275.png

Macro:

AkimasaKajitani_1-1607004930046.png

 


 

 

 

Labels
Top Solution Authors