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
Meteor

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

 

Spoiler
challenge1.jpg
Anurag
Atom

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
Quasar
Hey Anurag - welcome to the community and the weekly challenges!
Anurag
Atom

Thanks Seans

Natasha
Alteryx Partner

My solution before I learned about Generate Rows tool.

 

 

EstherB47
Asteroid
Spoiler
Spoilerimage.png