Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #71: Recreate SQL Joins in Alteryx

holly_jones12
Meteor

Good Challenge to learn about joining and unioning

Spoiler
image.png
ALTSkelly
Asteroid
Spoiler
Screenshot 2024-01-29 154647.png

Saampave
Meteoroid
Spoiler
image.png
olga_strubbe
Bolide

Thank you, @MattD!  This was a fun one, easy-peasy.  I found Alteryx joins similar to Tableau.  Thanks for the challenge - it was great to refresh my knowledge and see the commonalities and differences b/w Alteryx, Tableau and SQL in the logic. 

2024-01-31_09-42-35.png

asultanov
Asteroid
Spoiler
Screenshot 2024-02-01 093658.png
Carolyn
12 - Quasar
12 - Quasar

Fun one! Though I spent more time futzing with the Expect Equal tool than solving the actual challenge :D 

 

Spoiler
2024-02-16_10-01-13.png

Jeffreyx
Meteor
Spoiler
Screenshot 2024-03-25 113407.png
Alteralex
Asteroid
Spoiler
 

image_2024-03-25_114302027.png

JessicaRobbin
Meteor
Spoiler
 

JOINS AL.png

Spoiler
Screenshot 2024-03-25 114407.png