Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

Conditional Joins in Alteryx

In other data programs like access or Toad you can put conditions on a join. You can choose if something is greater than, less than, left join, right join, etc.
But with Alteryx you are only allowed to join a perfect match. It would be really great if you could add that functionality into 9.0
7 Comments
NeilR
Alteryx Alumni (Retired)
I made a macro that does some of the things you're talking about - you can check it out here: http://www.alteryx.com/community/blogs/engine-works/advanced-join-macro
Let me know what you think of it...
-Neil
adrian_loong
7 - Meteor
It would be great to have this functionality built in natively in Alteryx as most business users will need this condition. I've used the advanced macro however found that it may not be as efficient on larger datasets
bpschoon
7 - Meteor

I am also running into issues because I can't put conditions on my joins. I still have to work through SQL Server to do some things.

Falreign
6 - Meteoroid

We are trying out the Advanced Join Macro, looks good so far! Thanks goes out to NeilR.

 

If this was native it would be fantastic!

KylieF
Alteryx Community Team
Alteryx Community Team
Status changed to: Revisit

Thank you for our idea! Our product team was able to review this idea and have determined they cannot place it on the near future road map but would like to keep it in mind for future decisions. We'll update the status again once they are able to make those decisions on if or when this idea can be included on the road map.

Nag_Pithana
5 - Atom

we would surely  need a way out to create conditional join tool between tables/datasets within Alteryx. It is fundamental requirement for many problems that we try to solve.

amoghamd
5 - Atom

Hello Alteryx team, Is there an update on this Idea? Conditional joins are very basic and fundamental to join tables especially when you need to join between date ranges. The workarounds of using filters is cumbersome, affects processing time and not fool proof - there are situations when data gets filtered out which was not meant to be. Having used Tableau Prep - very surprising that Alteryx doesn't have this functionality.