Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2022 Day 4 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

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

43 REPLIES 43
bflick
8 - Asteroid

Finally got to use generate rows again. Brings back memories from last year.

Spoiler
bflick_0-1670130835823.png

 

trung2403
8 - Asteroid

I overthink it.

 

Spoiler
trung2403_0-1670131497350.png

 

clmc9601
13 - Pulsar
13 - Pulsar

I almost overcomplicated this one. Turned out pretty straightforward!

 

Spoiler
Screen Shot 2022-12-03 at 10.14.59 PM.png
atcodedog05
22 - Nova
22 - Nova

My take on this. I was literally freaking out while solving part-2 😅🤣🤣. My 2-tool Tool Golf solution I don't think it can be reduced more.

 

Spoiler
atcodedog05_0-1670131842281.png

 


 

 

Happy Analyzing :)
Cheers and have a nice day!

cgoodman3
14 - Magnetar
14 - Magnetar

@trung2403 For Tool golf you could probably convert your three text to columns into regex to parse the groups.

 

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
cgoodman3
14 - Magnetar
14 - Magnetar

I like seeing how @clmc9601 , @atcodedog05 and @trung2403  have solved it in fewer tool, but my brain worked more like @bflick today.

 

Spoiler
cgoodman3_0-1670131925105.png

So no where near tool golf, but pleased to have a functioning brain at 5am today!

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
DawnDuong
13 - Pulsar
13 - Pulsar

My best try for Golf is 3 tools for both parts 1 and 2.

Spoiler
DawnDuong_0-1670132010961.png

 

NicoleJ
Alteryx
Alteryx

Tool Golf = 2!! (No, that's not how I did it the first time, I chose instead to go the long way with several Text to Columns and a lot of confusion about which column was which in my formula comparisons... but I got there pretty quickly, nonetheless 😁)

 

Spoiler
NicoleJ_0-1670131993576.png

 

Cheers!
NJ
Manager, Product Management, Designer
Alteryx
grossal
15 - Aurora
15 - Aurora

Fun one today.

 

Normal:

 

Spoiler
grossal_0-1670132205664.png

 

 

Tool Golf:

Spoiler
grossal_1-1670132275430.png

 

 

Labels