Advent of Code 2023 Day 2 (BaseA Style)

[AlteryxCommunityTeam]

Spoiler

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

[AkimasaKajitani]

My solution.

Spoiler

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

 

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.

[CoG]

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

Part 1:

Spoiler

Part 2:

Spoiler

[phottovy]

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

Spoiler

[Yoshiro_Fujimori]

My solution.

Spoiler

Workflow

[Ladarthure]

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

[Carlithian]

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

[cgoodman3]

Spoiler

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

[AkimasaKajitani]

Tool Golf

Spoiler

 

[Kenda]

Spoiler

yay for the new product function in the Summarize tool!!

[FrederikE]

Spoiler