Advent of Code 2022 Day 9 (BaseA Style)

[AlteryxCommunityTeam]

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

[clmc9601]

Today I'm especially grateful for bridge engineers and concrete.

Spoiler

Workflow overall:

 

Part 1: The third multi-row formula updates both X and Y for the tail knot. It's an ugly mess of conversions to/from string, delimiter grouping, and conditional logic. 

 

 

 
Part 2: I reused my Part 1 tail coordinate calculation, adding on an additional eight tails. PSA: in any real-world workflow, this repeated section should definitely have been a macro.

 

[clmc9601]

And because my brain is (unfortunately) still wide awake, here's a visual representation of how the rope tail moved in part 2. I enjoy graphing unusual kinds of coordinates with the spatial tools like in weekly challenge #95 

Spoiler

 

[Pang_Hee_Choy]

hope have time to simply it.

Spoiler

part1:
extract data and get H position.
use macro to get T position. plan to use multiple row tool which is faster but hard to setup...

macro: 

part2:
repeat the macro x8...

thought it require more adjustment... (maybe it required but it two or more errors product a correct result)

[Jean-Balteryx]

Day 9 done ! ✔️

I think this one permanently damaged my brain ...

Spoiler

[grossal]

I will post my solution later once I annotated everything properly after work, but I wanted to share this little animation first (I hope GIFs work in the Community). Why did I build it? After spending roughly 2h with various approaches (including deleting everything twice), I decided to spend 30-40 minutes with an Excel file to visualize my input and check what was going wrong. Animation is posted in the spoiler. 

Spoiler

 GIF of the video (Alteryx has to approve the video ...)

Spoiler

[AkimasaKajitani]

I finished only part 1...If I complete the part 2, I will come back.

Spoiler

[DawnDuong]

It is getting tougher after every day and we are only at D9...

I opted to use iterative macro for ease of reading and debugging. My first attempt was not efficient, which after "refractor" decreased the runtime by 4x.

Spoiler

1) Step 1: Prepping the Coordinates first

2) Step 2: Actual solving

First iterative macro:

Second "standard" macro. This is used simply to wrap the 1st iterative macro before feeding it into another iterative macro (see note below).

Third macro, which is iterative

The strangest thing is for some reason, I cannot seem to be able to directly use an iterative macro in an iterative macro (the iteration keeps running even though there is nothing to loop). But if the 1st iterative macro is wrapped in a standard macro and that standard macro is used in a 2nd iterative macro then it works perfectly... 

It is strictly not AoC related, but if you want to take a look and help me figure out the mystery, the workflow is attached ^-^

[AkimasaKajitani]

I can come back. Part 2 is solved.

It seems that my approach is the same as a @clmc9601 's one. Today, It took a long time for debugging.

Spoiler

Macro: This macro is for only shorten the loop.

https://github.com/AkimasaKajitani/AdventOfCode/tree/main/2022

[patrick_digan]

Well this is one where I'm just glad I'm done.

Spoiler

Below are my workflow and macros. Brute Force all the way. I'm not including my scratch paper which was also critical in understanding different scenarios :)

Part2 Macro: