Advent of Code 2022 Day 5 (BaseA Style)

[AlteryxCommunityTeam]

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

[clmc9601]

Solved again using Python #SnakingMyWayThroughChallenges

Spoiler

 

[Ladarthure]

My solution with and iterative macro :)

Spoiler

Workflow :

Macro:

  

[PangHC]

Spoiler

remember to reverse string if you use transpose.

add check to pick whether want to use reversestring()

[SeanAdams]

I did this in 2 ways - one with an iterative macro that includes formulae; and one with an iterative macro that includes dynamic replace (thank you Digan).    I like the Dynamic Replace one a lot because it's one of the only easy-ish ways to do dynamic code execution in Alteryx (other than Chris's Dynamic creation of workflow XML)

Absolutely needs to be refactored - especially in the light of other people doing this without macros.

Also absolutely not gonna win any tool golf here...

Spoiler

The parser macro:

The Dynamic Replace Macro:

the formula version of the macro

[balders-ie]

10 tools, most of it parsing the data. I managed to do the stack moving with some hefty multi-row string calcs. 

Spoiler

 

[ApekshaSharma]

Sharing my No Macro approach for Day 5 :)

Spoiler

 

[DaisukeTsuchiya]

Spoiler

[Shelbey]

First time ever using a macro! That was a fun one.

Spoiler

[Watermark]

OMG, that formula ... lol,

ps sent you a note to connect on LinkedIn

[Watermark]

That's clever. I started down a similar to start, but couldn't make it work. Well done.