I remember this being the most recent challenge available when I first began using Alteryx. I tried forever trying to solve it but couldn't. Now that I know how to do iterative macros, it was a LOT easier and even managed to get it in the exact same order as the output solution. Definitely a milestone challenge for me.
OK – I spent way too long on this one.
I must admit – did this 5 different ways before looking at other people’s solutions and was super embarrassed by just how elegant @patrick_digan ; @vsoni ; @jdunkerley79 etc solutions were.
I threw everything at this - location optimizer; batch; iterative - they all worked for a subset, but not for the 50... Guess that's the pain of NP Complete type algorithms.
Welcome to the weekly challenges @LeahNeuenkirchen !