Challenge #1: Join to Range

[neilreinke]

Great to see everyone's solutions. We all think differently, but get to the same answer at the end.

[ShanaJoseph]

Here is my solution. I used a formula, join, and summarize. 

[LauraS1225]

Nice little introduction to a few different nodes for me! 

EDIT - wrong file.

[Rdscutters]

Hi, please see my solution for this challenge, thanks.

[paigej2012]

Here is my solution. 

[rcarog]

Solution attached.

[p_padham]

Hi everyone!

Here is my solution:

Spoiler

[apathetichell]

I could see using a macro or a generate rows on this - but I just went for it a fairly straight forward way...

[BeginnerMindset]

Spoiler

[GeorMich]

Trying to work through all the challenges!! **Fingers crossed**

Pretty much similar to the solution.

**SPOILERS

Split to column on the range

change data type on the new columns [1] and [2]

Generate rows on [1] using logic [1] <= [2]

Join to the other dataset using the postal Area

Summarize Group by (Region, Sales rep, Responder) and Count (Customer ID)

Thank you,

Michelle 🙂