Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAtook some time to figure out the cases, and punctuations.
The data is not very clean, but it did not matter for the join.
My solution
Here is my solution, it was good for me to know how to use Dynamic Rename tool!