Challenge #1: Join to Range

[Stoneage8988]

Week 1 solution,  got to learn more about how to use generate row tool, thanks. 

[Reesetrain2]

All,

I have been working forward from 1 and backwards from 157 to cover all of the Challenges.

-My solution used the Create Rows function, a Join and the summarize tool.

-Cheers!

Matt

[DanielG]

Starting from the beginning.  Completed my first weekly challenge (will not read additional comments or download the answers until I get them figured out).  Got my **bleep** handed to me in the Expert exam last week, so I need to whip myself into shape for next year.

Glad to see I solved it similar to most posts I read after the fact, using the Generate Rows Tool. 

Slowly rebuilding my Alteryx confidence...  :)

Onto #2...

[garthn555]

Spoiler

My solution

[garrettlem1017]

Solved this challenge two different ways. Solution one used generate rows tool to expand the ranges. The second solution used a switch statement in formula tool to determine the Region each Customer belonged to and joined on Region fields.

[Pokayoke]

Using Text to Columns and Generate Rows.

[phottovy]

My solution works when there is a relatively small number of regions but would need to be reworked if the number of regions increased significantly. Now to see how others tackled this problem.

Spoiler

[lilyvanbilsen]

Great weekly challenge. Allowed me to play around with the "Generate Rows" tool. Took a while to get the right input for the Initialization Expression and Condition Expression.

[acastelazo]

Here is my solution