Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

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.

13 Comments
jz
7 - Meteor

Like the idea, this is what we need

adrianloong
11 - Bolide

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

mceleavey
17 - Castor
17 - Castor

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.

ARich
Alteryx Alumni (Retired)
Status changed to: Under Review
 
ZaneT
6 - Meteoroid

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

adrianloong
11 - Bolide

+1

Atabarezz
13 - Pulsar

+1 a must have

RachelW
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. 

Atabarezz
13 - Pulsar

great news looking 4ward 2 it!

KylieF
Alteryx Community Team
Alteryx Community Team
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.