Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Join Multiple Left Outer Join

Please enhance the Join Multiple tool to include an option of:

 

"left outer join all on input 1".

 

Such a tool would be massively advantageous when data granularity is defined by one dataset (input 1) and many subsequent tables just need to be joined onto that input.

 

As-is, I have had to manually perform dozens of join + union sequences which seems both untidy and inefficient.

 

Such a feature would likely be more useful than existing options of full outer joins / inner joins which currently the tool allows.

1 Comment
AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes