ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

rachel_lynch
Alteryx
Alteryx
‎07-28-2022 07:17 AM

Fun! **PS - the Join Multiple tool is highly under-rated and has so many applications!

Spoiler
rachel_lynch_0-1659017853932.png

 

  

Rachel Lynch
challenge_71_rl.yxmd
Reply
0 Likes
AnnaLawrence
Alteryx
Alteryx
‎07-28-2022 01:22 PM

 

Spoiler
AnnaELawrence_0-1659039767852.png

 

 

 

71.yxzp
Reply
0 Likes
kaianderson
8 - Asteroid
‎07-29-2022 09:25 AM

Helpful reminder of difference between joins and outer joins.

challenge_71_KA.yxmd
Reply
0 Likes
FrederikE
13 - Pulsar
‎08-04-2022 02:41 PM
Spoiler
FrederikE_0-1659649257497.png

 

challenge_71_start_file.yxmd
Reply
0 Likes
jonathanwillis
8 - Asteroid
‎08-10-2022 12:21 PM

Here's my solution

challenge_71_jw_solution.yxmd
Reply
0 Likes
mgaronson
11 - Bolide
‎08-13-2022 04:39 AM

Great SQL join refresher and how to match to Alteryx! Love the solution overlayed onto the diagram.

challenge_71_Complete MGA.yxmd
Reply
0 Likes
martinding
13 - Pulsar
‎08-14-2022 03:09 PM
Spoiler
WeChat Screenshot_20220815080550.png

 

challenge_71_mysolution.yxmd
Reply
0 Likes
FinnCharlton
13 - Pulsar
‎08-18-2022 03:23 AM
Spoiler
FinnCharlton_0-1660818215941.png

 

challenge_71_complete.yxmd
Reply
0 Likes
bwins
8 - Asteroid
‎08-18-2022 07:00 AM
Spoiler
bwins_0-1660831189079.png

 

challenge_71_start_file.yxmd
Reply
0 Likes
ArnoldQ
7 - Meteor
‎08-19-2022 08:21 AM

ArnoldQ_0-1660922467294.png

Spoiler
 
Reply
0 Likes