We're excited to announce that we'll be partnering with Credly starting October 19th - see what this means and read the announcement blog here!

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

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
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
16 - Nebula

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.