Did this challenge on Day 2 of Week 3 of the ADAPT course. I have completed it only using the tools I know. My output is structured in a different way as the solution but contains the same info.
I solved this exercise based on the tools I have learned from Alteryx ADAPT program. This challenge was good to understand the real application of this tool.
Nice challenge, completed in as few steps as I could muster. My posted workflow requires the "names.yxdb" to be stored in the same folder as the saved workflow for it to run.