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

[bflick]

Definitely not my most elegant solution yet. Will come back to try without an iterative macro.

Spoiler

Main Workflow

Macro

[atcodedog05]

Hi @bflick,

Definitely looking forward to the one without the iterative macro 😀

[grossal]

I won't play Tool Golf today ...

Spoiler

Part 1 Macro:

Part 2 Macro:

[atcodedog05]

Day-5 here is my mess of a solution. It was fun though. I definitely need to improve 😅

Spoiler

Data prep:

Batch run workflow:

Macro:

Happy Analyzing :)
Cheers and have a nice day!

[cgoodman3]

@atcodedog05 interestering that you’ve used a batch macro 🧐 I’ll have a dive into that when I am not on my phone and can see the screenshot more.

[atcodedog05]

@cgoodman3 

Well, I went with saving iteration output to the staging files and reading it in again. Since I had used a similar approach recently this is what hit my mind. And later I batched it for each movement. This gave me good visibility of data flow in each tool of each iteration while each time running the macro. That's why I went with this. It's not much different 😅

[clmc9601]

I have a tendency to build metacode solutions: using Alteryx to dynamically assemble expressions/queries/workflows for me. If there were an eval() function, this nested macro could have been some kind of multi-row formula...

Spoiler

Workflow:

 Outer iterative macro:

 Inner batch macro:

[DataNath]

Decided last night that I'd set a 4:50am alarm to get up and give this a go as soon as it drops... Certainly didn't expect to be nesting a batch macro inside an iterative macro when I was jolted out of bed and I think it's a sign that nobody should ever get up early for anything.

Spoiler

Main workflow:

Iterative macro:

Batch macro:

Luckily because of the approach taken, the only change for Part 1 > 2 was removing ReverseString() here, re-saving the macros and hitting run again!

[AkimasaKajitani]

My solution.

I used Iterative macros. Suddenly the difficulty level increased.

Spoiler

Macro for Part1 and 2.  Almost the same, with one difference: the presence or absence of a ReverseString function.