Alteryx Designer Ideas

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

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

Submission Guidelines
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here

Joins on Inequalities

I would like to be able to use the join tool to join on inequalities.  We could join two tables, A and B on A.value is >= B.value1 AND A.value <= B.value2.  This would replicate the "between" function in SQL.  The equvalent feature in Tableau is pictured below.

10 Comments
Alteryx Partner

Like the idea, this is what we need

Alteryx Certified Partner
Alteryx Certified Partner

Currently the only easy way to do this is in native SQL code or using the advanced Join macro here 

http://community.alteryx.com/t5/Engine-Works-Blog/Advanced-Join-Macro/ba-p/2355

 

It would be great to have this functionality within the in-database (for Redshift) as it is quite common to join between 2 particular dates to get maximum benefit

Alteryx Certified Partner

This would be nice. In Qlik this functionality is called "Range matching", and is standard functionality. It seems like a relatively common and straightforward function.

Alteryx
Alteryx
Status changed to: Under Review
 
6 - Meteoroid

This feature is a must for any professional or even semi-professional database management or data analytics application. 

Alteryx Certified Partner
Alteryx Certified Partner

+1

Alteryx Partner

+1 a must have

Alteryx Alumni (Retired)
Status changed to: Under Review

Thanks for submitting this idea and comments. We're planning on making some improvements to Join next year, so I've logged this idea to be considered when we make those improvements. 

Alteryx Partner

great news looking 4ward 2 it!

Moderator
Moderator
Status changed to: Revisit

Thank you for your post! We are really interested in this idea, however we cannot fit this idea on the near future road map. We’ll keep this idea in mind however and update the status once we’re better able to speak on when and if we can implement it.