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 5 (BaseA Style)

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team

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

43 REPLIES 43
bflick
8 - Asteroid

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

Spoiler
Main Workflow
bflick_0-1670219664891.png

Macro

bflick_1-1670219688143.png

 

atcodedog05
22 - Nova
22 - Nova

Hi @bflick,

 

Definitely looking forward to the one without the iterative macro 😀

grossal
15 - Aurora
15 - Aurora

I won't play Tool Golf today ...

 

Spoiler
grossal_0-1670220128402.png

 


Part 1 Macro:

grossal_1-1670220188228.png

 

 


Part 2 Macro:

grossal_2-1670220223887.png

 

 

atcodedog05
22 - Nova
22 - Nova

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

 

Spoiler
Data prep:
atcodedog05_0-1670220301187.png

Batch run workflow:

atcodedog05_2-1670220357306.png


Macro:

atcodedog05_1-1670220318430.png

 



 

Happy Analyzing :)
Cheers and have a nice day!

cgoodman3
14 - Magnetar
14 - Magnetar

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

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
atcodedog05
22 - Nova
22 - Nova

@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
13 - Pulsar
13 - Pulsar

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:
Screen Shot 2022-12-04 at 11.29.45 PM.png

 Outer iterative macro:

Screen Shot 2022-12-04 at 11.24.31 PM.png

 Inner batch macro:

Screen Shot 2022-12-04 at 11.25.54 PM.png

 

 

DataNath
17 - Castor

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:

DataNath_0-1670223201401.png


Iterative macro:

DataNath_1-1670223219561.png


Batch macro:

DataNath_2-1670223268259.png

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!

DataNath_3-1670223448476.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

I used Iterative macros. Suddenly the difficulty level increased.

 

Spoiler
AkimasaKajitani_0-1670219901144.png

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

 

 

Labels