Challenge #1: Join to Range

[tochy]

[Gauthier_B]

My first challenge!

I had initially done it through a formula and then used the generate row tool. It simplifies the whole process.

[Inactive User]

I created min and max zip columns, appended it all together and got a good result.

[Kdpalmer]

Hi -- Instead of augmenting the second input with rows between the low and high end of the regional range, I categorized the first input's regions into the 5 categories with the formula tool.  I then joined on column from that output which had the information in the bins R1-R5 and used the summary tool -> select -> sort.

KP

[Mattpannuzzo]

My solution.

Probably similar to others, relatively easy one.

Spoiler

[coolvishruth]

Solution

[paultno]

Here is mine!  

[DVA]

Hi All,

My first post in this community and also my kick-off for the weekly challenge. A great opportunity to learn new things and looking forward to see how others approach the same problem.

Danny.

[jsdeter]

Posting my solution to Challenge 1