Challenge #1: Join to Range

[ShannonEWhite]

My solution to challenge 1 

[aude_czn]

Challenge 1 Complete

[anujc30]

Here is my solution: 

Used Select Records, Generate Rows, Union, Join and Summarize Tools to get the desired results.

[p-g]

Here's my solution using the Formula tool.

Spoiler

[psampaio005]

Spoiler

[JasonHu]

Spoiler

[alexnajm]

Nice use of Generate Rows (although it took a while to configure admittedly haha)!

[AndrewDataKim]

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. 

Spoiler

Solution:

[Postal1]<=[Postal Area] AND [Postal Area]<=[Postal2]

[joshbennett]

Here is my solution!

[HandsomeJih]

my solution is to use the formula function