alteryx Community

# General Discussions

Discuss any topics that are not product-specific here.

## Advent of Code 2020 - BaseA Style (Day 3)

16 - Nebula

22 REPLIES 22
7 - Meteor

My solution was similar to @jdunkerley79, but then again not quite.

Spoiler

7 - Meteor

@NicoleJohnson Still to early to think about reusing workflows. Day 8 or so we should probably start thinking along those lines. 😉

19 - Altair

I'll see @jdunkerley79's 10 tool solution and raise mine with 7

Spoiler

Used the "messy" substring() along with some modulo math to logically lengthen the rows as required. Technically I could remove the 1st filter and the following formula and cram the logic into the last filter tool, similar to what was used in Day 2 solutions, but that would just be silly 😂

Dan

15 - Aurora

This is Part1 of Day3 (I'll do part 2 when I finish a couple of meetings).

Needed help to understand the problem, thank @Niklas for your help!

Spoiler

Finally had the time to solve 2nd. part. Couldn't make it without Niklas and Jesse's help.! Thank you guys!

Spoiler

8 - Asteroid

My first year of AoC (@cgoodman3 has been nagging me and anyone else who will listen! 😝)

Today was definitely a step up from day 1 and 2 but managed it in the end!

Spoiler

Alteryx Alumni (Retired)

Figured I may as well start posting my solutions to these 🙂

This was definitely a fun one. I brute forced a solution to get some quick stars and then went back and fixed the logic.

Spoiler

I used a macro because I also figured this might come up again in the future.

The macro (with formula code snippet screenshot):

Happy to say mine runs in ~0.5 seconds, and uses relatively few tools.

14 - Magnetar

Great to see you taking part @Steph_Maddrell 👏

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

Totally brute force/copy paste

Spoiler

14 - Magnetar

Day 3.  Brute force instead of a macro.

Spoiler

11 - Bolide

Below is my solution utilizing an iterative macro which runs each part in under 1s individually and just at 1s together, which I felt pretty good about until I saw how fewer tools most of the other solutions have! 😂 Oh well, this one was fun to build!

Part 1:

Spoiler

Part 2:

Spoiler

Part 1 + Part 2:

Spoiler

Labels