Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
community Alteryx IO Alteryx.com
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
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

RobertOdera
13 - Pulsar
‎03-23-2019 01:45 PM
 
challenge_71_RNO2_Solution.yxmd
Reply
0 Likes
TonyA
Alteryx Alumni (Retired)
‎04-18-2019 06:18 PM

Here's my solution.

challenge_71_TonyA.yxmd
Reply
0 Likes
hbraunius
8 - Asteroid
‎04-22-2019 11:31 AM

My solution attached.

challenge_71_solution_hb.yxmd
Reply
0 Likes
hanykowska
11 - Bolide
‎05-21-2019 12:38 AM
 
challenge_71_solution_hanykowska.yxmd
Reply
0 Likes
Thableaus
17 - Castor
17 - Castor
‎05-23-2019 01:19 PM

Challenge #71, done.

 

Spoiler
Challenge_71.PNG

Cheers,

Challenge_71.yxmd
Reply
0 Likes
cgoodman3
14 - Magnetar
14 - Magnetar
‎05-26-2019 01:54 PM

My solution

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
challenge_71_solution.yxmd
Reply
0 Likes
T_Willins
14 - Magnetar
14 - Magnetar
‎06-14-2019 02:30 PM

Join and Union tools make this easy.  For a real challenge, recreate this in Excel...or don't since you never will again!

 

Spoiler
Workflow 71.GIF

 

challenge_71_solution.yxmd
Reply
0 Likes
papalow
8 - Asteroid
‎06-14-2019 09:29 PM

This was a good refresher on sql joins

challenge_71.yxmd
Reply
0 Likes
nakamott
8 - Asteroid
‎06-19-2019 03:50 PM

solution

challenge_71_TMN.yxmd
Reply
0 Likes
anaibeth
8 - Asteroid
‎06-20-2019 07:59 AM

Just realized I didnt really know how the join tool worked here on alteryx. This was great, thanks!!

 

Here's my solution.

Challenge 71.PNG

 

Reply
0 Likes
curated machine learning resources