We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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.

11 Comments
JohnJPS
15 - Aurora

@KylieF , I humbly recommend adjusting the roadmap. This should be easy to implement and is an obvious miss that competitive tools offer and is trivial even in raw SQL. This is a pretty big miss. There is now even a question on StackOverflow about it:

 

https://stackoverflow.com/questions/73199581/matching-numbers-that-are-close-in-value-in-alteryx

 

Please reconsider this and implement ASAP.