Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI highly recommend the video training Build Your First Iterative Macro! available in the Academy to get a better understanding of the way iterative macro work.
Wanted to make this accept varying input sizes, and scale beyond n=5 rows of input. We can view each employee-manager relationship as an edge in a directed acyclic graph. Using a V_WString as (approximately) a byte array to compactly represent those relationships, its easy to order the edges in the hierarchy. Ultimately, uses 2x joins to complete for any length of input up to ~30k rows.
great to see you practicing the macros... up next is it the reporting tool? 😉