Here's the Data Prep U solution! In case you haven't seen yet, we're also conducting a LIVE build with no preparation each week on our YouTube channel, and encourage everyone to join and participate in the conversation.
Spoiler
Screen shot of our solution:
Live build recording:
Even when following the assignment correctly, it seems some extra steps are needed to match the provided output.
Validation included:
I wouldn't recommend it, but I think you can get it down to 1 tool if you use add ins to get the New ID
