cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Welcome to Alteryx Academy! We hope you enjoy the journey. Let us know how we can improve your learning experience by completing this survey.
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.

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
Alteryx Certified Partner

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
Aurora
Aurora
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
Fireball
Spoiler
Spoilerimage.png

Guess I was too late to the party.

Aurora
Aurora

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

Never too late!