Advent of Code 2024 Day 1 (BaseA Style)

This is the ONLY use case in which I accept "Join by Record Position" as a valid configuration of the Join tool. Even here, it's shorthand. A more robust method, in my opinion, is to assign record IDs and use that as the join key.

2024_AoC_clmc9601_Day_01.yxmd

matthewblandford

Nice little warmup to start the month! Small enough to just load the raw data into the workflow itself.

Day 1 Solutions.yxmd

CoG

Simple yet great start to AoC 2024! This was a great warm up for what I know is to come.

Data Prep:

Spoiler

Both parts of the problem for Day 1 required the data be split into 2 independent columns. This is done quite easily with Text to Columns, Formula, and Select Tools:

Data Prep.png

Part 1:

Spoiler

Once the data is prepped, part 1 is almost trivial. Sort both sets of data, then Join together again, Ensure that proper data types for both fields, Compare with Formula Tool, and aggregate with the Summarize for the final answer!

Part 1 Section.png

Part 2:

Spoiler

For Part 2, we only need the count for each value in the second column, so we will immediately aggregate. Now, when the Join is performed (by record position for brevity), we will have the count of all values in the second column for every record in the first column (precisely what the problem calls for). The Formula Tool will again calculate our Similarity metric, and the Summarize Tool will provide us our answer!

Part 2 Section.png

Happy Solving to all others participating. I'm super excited for the rest of the days, so bring it on!

Main.yxmd

Gawa

AoC 2024 has just started!

Spoiler

Part1: To align two columns based on their position, 'Join by Record Position' is straightforward way, instead of putting Record ID for each and join by Record ID field.
Part2: As Left and Right columns has 'Many-to-Many' relationships, by joining these columns, number of rows will increase based on its cardinality. Just summing up number of Left columns will match the answer(no need of multiplying values).

2024D1_gawa.yxzp

JoshuaB

Seeing a lot of the same solution ideas! Well done. Such a great Alteryx type of puzzle!

Spoiler

2024_AoC_joshuaburkhow_Day_01.yxmd

ccanterman

After being peer pressured to solve Alteryx on a Saturday night, I have Day 1 complete. I'm glad this wasn't horrible!

Spoiler

Day 1.yxmd

AkimasaKajitani

My solution!

The tough long journey has started this year!

Spoiler

This year's day 01 is easier than last year's very much.

Day01.yxzp

ScottLewis

Nice to be back at it and to have started off soft.
I did fail the initial timezone check and entered my second answer with commas.

Good to get the bone stupid mistakes out of the way early.

Gawa

It's 'Cloud-able'☁️

I didn't realize Alteryx Designer Clouds now supports the Generate Row tool and the Multi Row Formula tool. The number of solvable puzzle by Designer Cloud would be much more than last year, I guess.

Spoiler

Malvim

Day 1

Spoiler

AkimasaKajitani

@gawa 　It is "Standard Mode". "Native Mode" is still not able to use Generate Row and Multi-Row formula. I hope to use macro in Designer Cloud. But I think that we can solve today's puzzle by Native mode.

DaisukeTsuchiya

Spoiler

DT2024_1.yxmd

AkimasaKajitani

Tool golfed.

Spoiler

8 tools except for input and the Browse tool.

Or for Part 1, I created no Join solution.

Spoiler

Day01.yxzp

caltang

That was fun!

Spoiler

caltang_AoC 2024_Day 1.yxzp

BS_THE_ANALYST

Gentle start! 😎

Spoiler

bs-solution.yxmd

afv2688

One more year, here we are again

Spoiler

AoC_2024_1.yxmd

NeoInfiniTech

Solution is attached.

Spoiler

Spoiler

Great way to get the party started, and a fun way to use the tools that we don't often get - see spoiler below.

Spoiler

The only odd thing here is splitting the records and doing a join by position in part 1 - we don't often get to do join by position, so this is fun.
Part 2 is a deliberate join explosion - generally you want to avoid this :-)