Challenge #1: Join to Range

[PeterGoldey]

starting late, but having fun

[jlaverne]

Attended Inspire 2018 and will now try to work through the weekly challenges.

[Christen_Marshall]

Looking forward to looking at the solution for this; it seems a little unintuitive/clunky to me to have to duplicate the rows to do a between clause when in SQL it'd be a single line of a between clause. I toyed with the idea of the advanced join macro but couldn't get it working... oh well. 

[Robert2]

Solution

[hbarcello]

My solution, with append tool

[svenk]

My Solution!

[kvnpt]

New to challenges.  Excited to learn

[cplewis90]

Definitely a good starter challenge. 

[JoyousOne]

My favorite part of this was coming up with the formula in the generate rows tool (shown in the spoiler).

2 challenges down; 119 to go! :D

Spoiler

tasty tasty formulastada!

[cspartz]

Starting at the beginning.