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.

[JohnJPS]

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

[simonaubert_bd]

Hey, it's implemented on Dataiku


Alteryx, would you really like your biggest competitor win on join? ;)

Best regards,

Simon

[simonaubert_bd]

By the way, the equivalent idea for in database :
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/In-db-join-with-other-operator-than-...