Challenge #1: Join to Range

[quandai]

Hi,

Attached is my solution.

[Tårtspade]

I finished the first challenge! Do I automatically get a badge by replying to a challenge with my completed workflow or how does the process look like? 

Attached is the workflow I did to solve the challenge.

[SwaroopSJ]

Spoiler

[Akash_16051995]

Attached the solution.

[DMContente]

My solution, from a while ago:

[EdE]

Here is my solution - I used a formula to separate the range into beginning and ending postal codes. 

[AcevedoYo]

Excited to start tackling these! Here is my solution

[LSchweinfurth]

Sharing my solution

Spoiler

[ChriswcNg]

Frist challenge and I'm liking it.

[Tylercram]

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.