Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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 RESPOSTAS 51
OllieClarke
15 - Aurora
15 - Aurora

Here's my first attempt:

Saqueador
OllieClarke_0-1670323490979.png

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

 

JamesCharnley
Pulsar
Saqueador
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
Bola de fogo
Saqueador
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.

Saqueador
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
Meteoro

Tried at first to do a massive if-else but finally came round to doing some regex 😅

 

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

Solution with one tool :)

 

Saqueador
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.

 

Saqueador
AkimasaKajitani_0-1670328755893.png

 

DawnDuong
13 - Pulsar
13 - Pulsar

Thanks @AkimasaKajitani  for sharing the formula. 

Rótulos
Autores com maior número de soluções