Challenge #1: Join to Range

[joelmiller66]

Spoiler

[MartinStraech]

Used similar solution.

Spoiler

[cherrington]

Challenge result

[jharber]

My solution to Challenge 1:

[Akash_chauhan]

Here's my Solution of Weekly challenge#1: Joint to Range

[bann-seamus]

Solution attached:

[TKSnider]

I know I'm really late to this party, but figured better late than never.

Spoiler

I didn't look through the solutions, so I'm sure this was done before, but I used a trick I've used in SQL to do this.  I parsed out the code range into a high and low, then appended the records and checked to see if they were between, if they were, I added a 'keep' flag and then filtered out all the NOs.  Followed that with a summarize tool.  And then to validate the results, I joined my results to the given results using the three key fields.

[Mario36]

Here's my solution.

[ARussell34]

Here is my solution!

[RamonaJ]

Attached my solution