A nice break from all the iterations
More generate rows!
Nicole's pro tip for today: Pay attention to the field length in your initial data input. 254 characters is not enough, and you will waste 10 minutes questioning everything you ever knew about Alteryx before realizing this. #AskMeHowIKnowThis
Cheers!
NJ
Also got to use my input macro! But I didn't wake at 5am so lost out on the speed points!
edit: I’ve just realised we are not solving a factorial in part two as n! = n*(n-1)! And we are adding consecutive values not multiplying. Well at least I was doing the right thing in my solution just calling it the wrong thing!
Edit: there’s an even better way, part 1 is just the median of all the starting positions and in general part 2 can be evaluated to the mean (+/-1) 😲 https://www.reddit.com/r/adventofcode/comments/rars4g/2021_day_7_why_do_these_values_work_spoilers/?...
I need to read the directions more carefully - I put in the position instead of the fuel amount and couldn't figure out my "mistake" for 30 minutes 😩In hindsight I probably didn't need the batch macro.
At Day07, I use the Generate Row tool to make all positions.
GitHub
https://github.com/AkimasaKajitani/AdventOfCode/tree/main/2021
Cannot escape the mindset of using macro now. After missing the straight line formula, I am glad to be able to use formula for arithmetic sum today.