Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAAs a novice coming from a programming background, I immediately thought of this as an iterative process and went to an iterative macro (my first time). So I learned a lot about iterative macros and then learned how an experience Alteryx designer (note the small "d") approaches a problem like this. Definitely need to revise my thinking about how to leverage tables to do what normally is done in loops. Anyway, here is my weird iterative macro solution to the challenge.