cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #1: Join to Range

mceleavey
Alteryx Certified Partner

I know, it's really addictive.

I Alteryx socially. I can stop whenever I want...

BenMoss
Alteryx Certified Partner

As mceleavey says, this is too addictive!

 

 

Laurap1228
Asteroid

First things first! I am going through the weekly challenges in order. Here is my solution to challenge #1

 

Spoiler
challenge1.jpg
Anurag
Meteoroid

Nice One!!

 

I used Formula tool to create a new column of Region in the first input table, and then joined both the table based on the Primary Key Column "Region". After that I used Summarize tool to Group by and count as per the desired output.

Highlighted
Pulsar
Hey Anurag - welcome to the community and the weekly challenges!
Anurag
Meteoroid

Thanks Seans

Natasha
Alteryx Certified Partner

My solution before I learned about Generate Rows tool.

 

 

EstherB47
Asteroid
Spoiler
Spoilerimage.png

Guess I was too late to the party.

Pulsar

welcome @karan-sanas - great to see you tackling the challenges.

Never too late!