We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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)

Jean-Balteryx
15 - Aurora

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

22 REPLIES 22
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
15 - Aurora

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
15 - Aurora

@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