Joins on Inequalities

[matthew_slaughter]

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.

[jz]

Like the idea, this is what we need

[adrianloong]

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]

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.

[ZaneT]

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

[adrianloong]

+1

[Atabarezz]

+1 a must have

[RachelW]

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]

great news looking 4ward 2 it!

[KylieF]

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.