community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

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.

9 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
 
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!