Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

mbogusz
9 - Comet
‎09-26-2019 11:09 AM
Spoiler
Joins, Join Multiples, and UnionsJoins, Join Multiples, and Unions
challenge_71_solution_mbogusz.yxmd
Reply
0 Likes
varunvarma87
8 - Asteroid
‎09-26-2019 05:52 PM

Challenge 71 completed

Spoiler
2019-09-27 10_50_17-Window.png
challenge_71_start_file.yxmd
Reply
0 Likes
Laszlo_D
8 - Asteroid
‎10-01-2019 06:07 AM

image.png

challenge_71_solution_LD.yxmd
Reply
0 Likes
jagdeep_singh85
8 - Asteroid
‎10-11-2019 03:48 AM

PFA my solution

challenge_71_Solution(By_Jagdeep).yxmd
Reply
0 Likes
Inactive User
Not applicable
‎10-20-2019 02:28 PM
 
challenge_71_start_file.yxmd
Reply
0 Likes
RoDO
8 - Asteroid
‎10-23-2019 08:14 AM

My spaghetti solution:

 

Spoiler
challenge_71_RODO_Solution.png
challenge_71_RODO_Solution.yxmd
Reply
0 Likes
sgrabish1
8 - Asteroid
‎10-23-2019 10:48 AM

Thanks for practice exercise!

challenge_71_sjg.yxmd
Reply
0 Likes
SueDonim
8 - Asteroid
‎11-05-2019 04:45 PM

This was very helpful in understanding the various joins (my past experience was in <shudder> Access <\shudder>, and I never quite understood the various types.

 

Spoiler
Won't go through the process this time as it is straight-forward for each example

MySolution.PNG
challenge_71_SueDonim Solution.yxmd
Reply
0 Likes
ArnavS
Alteryx Alumni (Retired)
‎11-06-2019 10:33 AM
 
challenge_71_start_file.yxmd
Reply
0 Likes
JennyMartin
9 - Comet
‎11-13-2019 07:27 AM
Spoiler
AWC71.PNG

Great learning resource for those familiar with SQL.

AWC71.yxmd
Reply
0 Likes
Live Weekly Challenge