Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution to challenge 1
Going back through the weekly challenges and starting from scratch. I chose to use the Advanced Join for this one to make it easier to establish a relationship for which regional rep the customer belonged to. By using the cross join I was able to accomplish the resilts in less steps because it works like a conditional join.
Solution: