Advent of Code 2022 Day 3 (BaseA Style)

[AlteryxCommunityTeam]

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

[grossal]

I tried to avoid Join-Tools as a little extra challenge for Tool Golf.

Spoiler

For the normal one ... let's not talk about what I was doing after 3h of sleep. It's a mess, but here it is.

Spoiler

After @patrick_digan  showed his three-tool approach for 1 ... I had to redo mine just for the fun and brought it down to two tools. All the credit goes to Digan. I won't post the secret, as this honor should belong to him.

Spoiler

[DavidP]

Got to use my favourite tool - Tile!!! Optimizing for tool golf will have to wait until this evening.

Spoiler

[patrick_digan]

I had fun with this one

Spoiler

I went for some creative formula work with the ReplaceChar function

[trung2403]

A bit challenging today!

[DataNath]

Day 3 complete! Crazy to see some of the low tool solutions here but happy to get this done whilst nursing a hangover!

Spoiler

[atcodedog05]

My take on this

Spoiler

Happy Analyzing :)

Cheers and have a nice day!

[Kenda]

Spoiler

Hot tip - The elves appreciate when you build your AoC workflows vertically

[LiuZhang]

Spoiler

@NicoleJ multi-join is a good call, forgot about it. I think Make Columns tools will come in handy for the challenges now 👍 Though Tile is still my go to.

EDIT: ok, @patrick_digan 's ReplaceChar is more impressive, I am going to use that as string search now 👏

[kelsey_kincaid]

Should have been smarter about my a-z A-Z generation. There's little I love more than tokenizing to rows to set up some joins, though. Fun one today!

Spoiler

[SeanAdams]

Starting to feel a little like AOC is warming up!

Here's the first pass - the dirty solution before refactor.

Spoiler

and the detailed view: