Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #1: Join to Range

Highlighted
6 - Meteoroid

I'm late to the game but I hope I can still collect those badges. 

 

Process used once I had the input data sets:

Spoiler
1. I used the append tool to join the source reference table to the target customer table. 
2. Inserted a filter with a series of ([postal code] >= n AND [postal code] <= n AND [region] = "R_" to isolate the rows that had the correct Region and Rep appended. 
3. Used the summary tool to group by Region, Rep, Responder, and then list the customer count for each category. 

 

Highlighted
7 - Meteor

Late onto this but am trying to learn as much as possible.

Highlighted
8 - Asteroid
8 - Asteroid

Congrats! How many challenges do you think you'll do?

Highlighted
11 - Bolide
Spoiler
 
Highlighted
7 - Meteor
Spoiler
Weekly challenge 1.PNG
Highlighted
8 - Asteroid

Challenge 1

Highlighted
8 - Asteroid
8 - Asteroid

Another challenge in the bag!

Highlighted
7 - Meteor

Easiest and simple Solution !!

Highlighted
6 - Meteoroid

Here is my solution

Highlighted
7 - Meteor

Solution to Challenge #1: Join to Range