In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Director, Product Management
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

 

 

 

cgoodman
ACE Emeritus
ACE Emeritus

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
Top Solution Authors