General Discussions

Discuss any topics that are not product-specific here.

Advent of Code 2022 Day 6 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

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

51 REPLIES 51
OllieClarke
15 - Aurora
15 - Aurora

Here's my first attempt:

Spoiler
OllieClarke_0-1670323490979.png

There must be a single formula solution using RegEx. Will look for it now

 

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1670324173025.png

 

Might be a bit of an overcomplication but I've built so many iteratives recently this might actually be faster for me than messing around in formulas.

leozhang2work
10 - Fireball
Spoiler
WorkflowWorkflowIterative macroIterative macro

Never tried so many iterations, a first for me.

DawnDuong
13 - Pulsar
13 - Pulsar

My first attempt, which uses iterative macro, is based on intuition. Part 1 and Part 2 are similar.

Spoiler
Iterative macro:
DawnDuong_0-1670326487295.png

 

Main workflow:
DawnDuong_1-1670326519222.png

 

Will look through others' solutions especially the crazy Regex / Formula tool ones :)

DawnDuong
13 - Pulsar
13 - Pulsar

Very neat Formula tool @atcodedog05 

DawnDuong
13 - Pulsar
13 - Pulsar

Combining the formula and the Generate row into a single Generate Row is a super idea @AkimasaKajitani , can you share how you did that?

Carlo_S
7 - Meteor

Tried at first to do a massive if-else but finally came round to doing some regex ðŸ˜…

 

Spoiler
SpoilerScreenshot 2022-12-06 114253.png
afv2688
16 - Nebula
16 - Nebula

Solution with one tool :)

 

Spoiler
afv2688_0-1670327923027.png

 

AkimasaKajitani
17 - Castor
17 - Castor

Here is the Generate row setting of my 2nd solution. I think that the expression is too long.

 

Spoiler
AkimasaKajitani_0-1670328755893.png

 

DawnDuong
13 - Pulsar
13 - Pulsar

Thanks @AkimasaKajitani  for sharing the formula. 

Labels
Top Solution Authors