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 3)

Alteryx Certified Partner

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

16 - Nebula
16 - Nebula

Day 3 - getting trickier, needed more thought

 

Spoiler
jdunkerley79_0-1606976435159.png

 

14 - Magnetar
14 - Magnetar

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

16 - Nebula
16 - Nebula

@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

 

Alteryx Certified Partner

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
12 - Quasar
12 - Quasar

Day 3 reminds me of this

 

SQCNh1k.gif

 

Spoiler
cgoodman3_0-1606983931310.png

 

Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
12 - Quasar
12 - Quasar

@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.

Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Alteryx Certified Partner

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

12 - Quasar
12 - Quasar

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.

Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Alteryx Certified Partner

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