Challenge #1: Join to Range

[akhansen246]

Challenge 1 - Completed

[InchulKo]

Here is my solution!

[Gem]

Spoiler

[EricL0399]

My challenge Solution:

Spoiler

Split the ranges of postal codes into two columns, parsing on the hyphen.  Use a Generate rows tool to create a row for each postal code using the Lower Range [PostStart] and Upper Range [PostEnd] numbers as counting limits within the formula.  Join the data set on the postal codes, so now each customer ID has The Region and Rep associated with it.  Did not include the Expected Revenue at this point in the flow because it didn't feel relevant/usable in the join.  Quick Summary and done.

Generate Rows formula:  [PostalCode] = [PostStart]; while PostalCode <= [PostEnd]; [PostalCode] + 1 

[revenkatesh]

My solution.

[MDestra]

Challenge #1 Result.

[EnglishmaninNY]

I used what I call an "open join" but I see now that append tool basically does the same thing and is better way to go. I was unfamiliar with the Generate rows tool and that is more elegant to me as it avoids generating so many rows. Thanks

Spoiler

[orangebomber]

Spoiler

[williamnolan03]

Pretty fun start

[jokern]

Solution for Challenge #1