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

Jean-Balteryx
13 - Pulsar

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

jdunkerley79
16 - Nebula
16 - Nebula

Day 3 - getting trickier, needed more thought

 

Spoiler
jdunkerley79_0-1606976435159.png

 

NicoleJohnson
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

jdunkerley79
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

 

Jean-Balteryx
13 - Pulsar

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

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

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

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

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

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

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