We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2023 Day 2 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Spoiler
 

Discussion thread for day 2 of the Advent of Code - https://adventofcode.com/2023/day/2

64 REPLIES 64
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
 
スクリーンショット 2023-12-02 150914.png

I used the RegEx tool to be easier for after part.

スクリーンショット 2023-12-02 151837.png

 

Designer Cloud version

Spoiler

Designer Cloud sampled the data, so I need to run the workflow to know the complete result. But I could make this workflow by the same approach of Designer Desktop.

スクリーンショット 2023-12-02 150853.png

 

AndrewDMerrill
13 - Pulsar

Not my first draft, but probably one of the simplest forms the solution can take:

Part 1:

Spoiler
Part 1_2.png

Part 2:

Spoiler
Part 2_2.png
phottovy
13 - Pulsar
13 - Pulsar

How dare they let me regain a tiny bit of confidence!

 

Spoiler
02.png
Yoshiro_Fujimori
14 - Magnetar

My solution.

Spoiler
Workflow
AoC02_WF.png
Ladarthure
14 - Magnetar
14 - Magnetar

A lot easier today, no head banging on a saturday morning is appreciable :D

Carlithian
10 - Fireball

Silly mistake on my part made this take way longer than it should have, but learnt something new with Regex, so happy with that :)

 

Spoiler
Screenshot 2023-12-02 102513.png

 

cgoodman3
14 - Magnetar
14 - Magnetar
Spoiler
day2_2023.png

A nice simple part 2. I felt like this one was a perfect showcase for Alteryx on splitting data and then aggregating.

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

Tool Golf

Spoiler
スクリーンショット 2023-12-02 195115.png

Kenda
16 - Nebula
16 - Nebula
Spoiler
yay for the new product function in the Summarize tool!!

 

image.png

FrederikE
13 - Pulsar
Spoiler
 
Screenshot 2023-12-02 121047.png

 

Labels