General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2022 Day 2 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

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

45 REPLIES 45
NicoleJ
Alteryx
Alteryx

If you have not read the children's book "The Legend of Rock Paper Scissors", I HIGHLY recommend it as a complement to today's challenge. 

 

"Are you not entertained?!?"

 

Spoiler
NicoleJ_0-1669958895920.png

 

Cheers!
NJ
Sr. Manager, Product Management, Designer
Alteryx
bflick
8 - Asteroid

I struggled most with understanding the rules. Really need to read twice build once instead of build 5 times read once.

 

Spoiler
bflick_0-1669959516159.png

When in doubt mapping files solve everything

 

clmc9601
13 - Pulsar
13 - Pulsar

I made some manual assignments instead of writing a long formula. The tradeoff paid off in speed given there were a fixed number of outcomes. Not my most dynamic solution...

 

Spoiler
Screen Shot 2022-12-01 at 10.41.24 PM.png

 

atcodedog05
22 - Nova
22 - Nova

My Solution for AOC Day-2 

 

Spoiler
atcodedog05_0-1669960019831.png

 

Cheers and happy analyzing!

 

atcodedog05
22 - Nova
22 - Nova

@clmc9601 Very nicely done 😁. I guess it shows we should do some thinking before we start dragging the tools onto Canvas to solve the problem 😂.

grossal
15 - Aurora
15 - Aurora

Today ... the missing sleep really came into play ... 

 

Spoiler
grossal_0-1669961559904.png

 

 

I also played tool golf and actually found a pretty smart way to do the score formula without nesting 6 IFs:

Spoiler
grossal_1-1669961621182.png

 

grossal_2-1669961660413.png

 

 

 

cgoodman3
14 - Magnetar
14 - Magnetar

I'm embarrassed with how long I took, so here's my refactored version

Spoiler
cgoodman3_0-1669961712549.png


Originally parsed out the letters and then built complicated IF statements which with my 5am brain meant I had typos and just couldn't see it, so ended up getting some paper out and writing the logic down in a matrix.

image.jpg

 I even messed up this!



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

My solution. There are no IF statements. But my workflow has many hand-made tables.This is similar to @clmc9601 's approach, but not as elegant as hers.

 

Spoiler
AkimasaKajitani_0-1669962120014.png

 

 

Jotigautam
10 - Fireball

If-else Era it is! 😃

 

Spoiler
Jotigautam_0-1669965210446.png

 

 

Labels