Challenge #1: Join to Range

[coracai]

My solution. 

[devX511]

Late to Party! Joining to learn!

[murciadaniel]

Thanks for the challenge. I just started with Alteryx this week and solved using Core certificate tools. Looking at other responses, I see that there is a generate rows toll which I'll definitely explore. 

I appreciate it's a bit sub-optimal, so please bear with me 😉

[AndreasVoinescu]

My solution is attached (not very scalable, since it requires a manual formula based on values).

Spoiler

Created range via multiple IF clauses> join both files > Count Customers and group by other columns

[lkmounir]

Done!

Spoiler

[ayazsheikh]

Spoiler

Pretty Easy and Straight Forward.

[caconrad03]

Starting from the bottom 🙂

[FlorianC]

Crafty little challenge.

Spoiler

[jimmygatliff]

🙂

[jarrod]

took a bit to figure out Generate Rows within python, but finally figured it out.

Spoiler

#SnakingMyWayThruChallenges