Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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